We are on 11.5.7 we have PO Requisition Approval & PO Approval workflow. Can we have a workflow that sends notification when an item is received to the requester and preparer? Any advice please or is it better to do it thru Oracle Alert.
My Company Has 11i PO-AP-FA-GL
HR-AR-Is Been Integrated With Other System
My Data Warehouse Guy Wants Data From PO-AP-FA-GL Any Idea How To Go About This And What Table Info I Need To Give Has Any One Done This Any Info Will Be Appreciated.
Thanks In Advance
I need list of all vendors. with this I am getting some duplicate any help plz
SELECT
distinct pv.vendor_id,
pv.vendor_name ,
pvs.address_line1,
pvs.address_line2,
pvs.address_line3,
pvs.city ,
pvs. state,
pvs.zip
FROM po.po_vendors pv , apps.po_vendor_sites pvs
WHERE pv.vendor_id =...
In PO there is CLOSED_CODE we want to 'FINALLY CLOSED' all PO which have the CLOSED_CODE ='CLOSED' and the PO's are 30 days old like all the closed to finally closed we dont want to go one by one is there a update statment any help and any thing to look for or any automatic way do it. we have a...
SELECT * FROM FND_CONCURRENT_REQUESTS WHERE REQUEST_ID= 007
update statment for argument14,argument15,and ARGUMENT_TEXT
which is '1, 1, MSTK, CUSTOMER_NAME, USC, D, , , , , , , , 01-FEB-04, 05-FEB-04, USD, N, N'
need to update inside ARGUMENT_TEXT the date to_char and to_date
and argument14...
I have mtl_system_items
item,user_item_type,item_status
and in the flexfield i have like 10 attribute
In some of the attribute have data in another table like lookup and other table I want to join like 5 tables but the mtl_system_items show's the code like AA and other table has the meaning...
I have 8 org_id and more then 10000 order_number I need to find the distinct org_id and just 1 order_number in all org_id to test there currency may be org_id,order_number,currency from oe_order_headers_all
Thanks
I need a query please any help
if you do a select * from all_tables I need to find out similar table which ends with _all and _tl
the reason I want to make a view _VL. eg:
oe_headers_types_all
oe_headers_types_tl
Th
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.