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_UI_RCV_LOVS dependencies on OE_ORDER_LINES_ALL

Line 1187: oe_order_lines_all oel,

1183: oec.customer_number
1184: FROM rcv_transactions rt,
1185: rcv_supply ms,
1186: oe_order_headers_all oeh,
1187: oe_order_lines_all oel,
1188: -- oe_line_types_v oet,
1189: OE_TRANSACTION_TYPES_TL OTT_TL,
1190: OE_TRANSACTION_TYPES_ALL OTT_ALL,
1191: oe_sold_to_orgs_v oec

Line 1237: OE_ORDER_LINES_all OEL,

1233: --OEC.customer_number
1234: PARTY.PARTY_NAME CUSTOMER_NAME,
1235: PARTY.PARTY_NUMBER CUSTOMER_NUMBER
1236: FROM
1237: OE_ORDER_LINES_all OEL,
1238: OE_ORDER_HEADERS_all OEH,
1239: OE_TRANSACTION_TYPES_TL OTT_TL,
1240: OE_TRANSACTION_TYPES_ALL OTT_ALL,
1241:

Line 1293: oe_order_lines_all oel,

1289: FROM rcv_transactions_v rtv,
1290: oe_order_headers_all oeh,
1291: OE_TRANSACTION_TYPES_TL OTT_TL,
1292: OE_TRANSACTION_TYPES_ALL OTT_ALL,
1293: oe_order_lines_all oel,
1294: -- oe_line_types_v oet,
1295: oe_sold_to_orgs_v oec
1296: WHERE oeh.header_id = rtv.oe_order_header_id
1297: AND rtv.receipt_source_code = 'CUSTOMER'

Line 2026: OE_ORDER_LINES_all OEL,

2022: NULL FIELD13,
2023: lookup_code FIELD14 ,
2024: to_char(oel.org_id) FIELD15
2025: FROM fnd_lookup_values_vl flv,
2026: OE_ORDER_LINES_all OEL,
2027: OE_ORDER_HEADERS_all OEH,
2028: --OE_LINE_TYPES_V OLT, --bug3173013
2029: OE_TRANSACTION_TYPES_TL OTT_TL,
2030: OE_TRANSACTION_TYPES_ALL OTT_ALL,

Line 2665: OE_ORDER_LINES_all OEL,

2661: NULL FIELD13,
2662: lookup_code FIELD14 ,
2663: to_char(oel.org_id) FIELD15 --
2664: FROM fnd_lookup_values_vl flv,
2665: OE_ORDER_LINES_all OEL,
2666: OE_ORDER_HEADERS_all OEH,
2667: --OE_LINE_TYPES_V OLT, --bug3173013
2668: OE_TRANSACTION_TYPES_TL OTT_TL,
2669: OE_TRANSACTION_TYPES_ALL OTT_ALL,

Line 7451: oe_order_lines_all oel,oe_order_headers_all oeh--Bug 3972931-Added the table oe_order_headers_all

7447: WHERE organization_id = p_Organization_Id
7448: and concatenated_segments like p_concatenated_segments||l_append
7449: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
7450: and inventory_item_id IN (SELECT oel.inventory_item_id FROM
7451: oe_order_lines_all oel,oe_order_headers_all oeh--Bug 3972931-Added the table oe_order_headers_all
7452: WHERE oel.HEADER_ID = p_oeOrderHeaderID
7453: and oel.header_id = oeh.header_id --Bug4060261 -Added the join between the tables.
7454: and oel.ORDERED_QUANTITY > NVL(oel.SHIPPED_QUANTITY,0)
7455: and ((p_projectId is null or oel.project_id = p_projectId)

Line 7526: oe_order_lines_all oel,oe_order_headers_all oeh--Bug 3972931-Added the table oe_order_headers_all

7522: ) )
7523: and mcr.inventory_item_id = msi.inventory_item_id
7524: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
7525: and msi.inventory_item_id IN (SELECT oel.inventory_item_id FROM
7526: oe_order_lines_all oel,oe_order_headers_all oeh--Bug 3972931-Added the table oe_order_headers_all
7527: WHERE oel.HEADER_ID = p_oeOrderHeaderID
7528: and oel.header_id = oeh.header_id --Bug4060261-Added the join between the tables.
7529: and oel.ORDERED_QUANTITY > NVL(oel.SHIPPED_QUANTITY,0)
7530: and ((p_projectId is null or oel.project_id = p_projectId)