eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_TRANSACTION_FLOW_PUB dependencies on IC_WHSE_MST

Line 3261: FROM ic_whse_mst WHS

3257:
3258: IF l_doc_type = 'OMSO' THEN
3259: SELECT WHS.mtl_organization_id, oeh.ordered_date
3260: INTO l_organization_id, l_transaction_date
3261: FROM ic_whse_mst WHS
3262: , oe_order_lines_all OEL
3263: , oe_order_headers_all OEH
3264: WHERE OEL.line_id = l_line_id
3265: AND oel.header_id = oeh.header_id

Line 3270: FROM ic_whse_mst WHS

3266: AND WHS.whse_code = l_whse_code;
3267: ELSIF l_doc_type = 'PORC' THEN
3268: SELECT WHS.mtl_organization_id, oeh.ordered_date
3269: INTO l_organization_id, l_transaction_date
3270: FROM ic_whse_mst WHS
3271: , oe_order_lines_all OEL
3272: , oe_order_headers_all OEH
3273: , rcv_transactions RCT
3274: , po_requisition_headers_all poh

Line 5024: from ic_whse_mst WHS

5020: if l_doc_type = 'OMSO' then
5021: begin
5022: select oel.pricing_date
5023: into l_trf_price_date
5024: from ic_whse_mst WHS
5025: , oe_order_lines_all OEL
5026: where OEL.line_id = l_line_id
5027: and WHS.whse_code = l_whse_code;
5028: exception

Line 5039: from ic_whse_mst WHS

5035: elsif l_doc_type = 'PORC' THEN
5036: begin
5037: select oel.pricing_date
5038: into l_trf_price_date
5039: from ic_whse_mst WHS
5040: , oe_order_lines_all OEL
5041: , rcv_transactions RCT
5042: , po_requisition_lines_all pol
5043: where pol.requisition_line_id = oel.orig_sys_document_Ref