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 OE_ORDER_LINES_ALL

Line 3051: FROM oe_order_lines_all

3047:
3048: BEGIN
3049: SELECT org_id, ship_from_org_id
3050: INTO l_selling_ou, l_ship_from_org_id
3051: FROM oe_order_lines_all
3052: WHERE
3053: header_id = l_header_id AND
3054: line_id = l_line_id;
3055: EXCEPTION

Line 3262: , oe_order_lines_all OEL

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
3266: AND WHS.whse_code = l_whse_code;

Line 3271: , oe_order_lines_all OEL

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
3275: , po_requisition_lines_all pol

Line 3314: FROM oe_order_lines_all oel, oe_order_headers_all oeh

3310: -- this is a true drop ship with procuring flow
3311: BEGIN
3312: select oel.ship_from_org_id, oeh.ordered_date
3313: into l_organization_id, l_transaction_date
3314: FROM oe_order_lines_all oel, oe_order_headers_all oeh
3315: where oel.line_id = p_reference_id
3316: AND oel.header_id = oeh.header_id;
3317: EXCEPTION
3318: WHEN NO_DATA_FOUND then

Line 3829: , oe_order_lines_all l

3825:
3826: select l.ato_line_id,l.header_id
3827: into l_ato_line_id,l_order_header_id
3828: from mtl_material_transactions mmt
3829: , oe_order_lines_all l
3830: WHERE MMT.transaction_id = p_transaction_id
3831: AND l.line_id = mmt.trx_source_line_id;
3832:
3833: SELECT line_id

Line 3835: from oe_order_lines_all

3831: AND l.line_id = mmt.trx_source_line_id;
3832:
3833: SELECT line_id
3834: INTO l_order_line_id
3835: from oe_order_lines_all
3836: where header_id=l_order_header_id
3837: and ato_line_id=l_ato_line_id
3838: and inventory_item_id=p_inventory_item_id;
3839: ELSE

Line 4593: FROM oe_order_lines_all oel, oe_order_headers_all oeh

4589: print_debug('Inside p_drop_ship_flag = Y', 'GET_TRANSFER_PRICE');
4590: BEGIN
4591: select oeh.ordered_date
4592: into l_transaction_date
4593: FROM oe_order_lines_all oel, oe_order_headers_all oeh
4594: where oel.line_id = p_transaction_id
4595: AND oel.header_id = oeh.header_id;
4596: EXCEPTION
4597: WHEN NO_DATA_FOUND then

Line 4987: from oe_order_lines_all oel

4983: print_debug('Inside p_global_procurement_flag = N', 'GET_TRANSFER_PRICE_DATE');
4984: begin
4985: select oel.pricing_date
4986: into l_trf_price_date
4987: from oe_order_lines_all oel
4988: where oel.line_id = p_order_line_id;
4989: exception
4990: when no_data_found then
4991: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SALES_ORDER');

Line 5025: , oe_order_lines_all OEL

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
5029: when no_data_found then

Line 5040: , oe_order_lines_all OEL

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
5044: and oel.order_source_id = 10

Line 5065: from oe_order_lines_all oel

5061: if( p_drop_ship_flag = 'N') then
5062: begin
5063: select oel.pricing_date
5064: into l_trf_price_date
5065: from oe_order_lines_all oel
5066: where oel.line_id = p_order_line_id;
5067: exception
5068: when no_data_found then
5069: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SALES_ORDER');

Line 5079: FROM oe_order_lines_all oel

5075: -- this is a true drop ship with procuring flow
5076: BEGIN
5077: select oel.pricing_date
5078: INTO l_trf_price_date
5079: FROM oe_order_lines_all oel
5080: where oel.line_id = p_transaction_id;
5081: EXCEPTION
5082: WHEN NO_DATA_FOUND then
5083: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_SALES_ORDER');