Search results for query: *

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...

Hi Dear, I need to open forms and report from UNIX whats the .. like $6...some thing forgot please help Thanks in advance :)

Hi Dear, I need to open forms and report from UNIX whats the .. like $6...some thing forgot please help Thanks in advance :)

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...

Thanks that was perfect Thanks!

sir with that query I am only getting one org_id if i want muntiple org_id and order_num how can I do that Thanks

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