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 1155: oe_order_lines_all oel,

1151: oec.customer_number
1152: FROM rcv_transactions rt,
1153: rcv_supply ms,
1154: oe_order_headers_all oeh,
1155: oe_order_lines_all oel,
1156: -- oe_line_types_v oet,
1157: OE_TRANSACTION_TYPES_TL OTT_TL,
1158: OE_TRANSACTION_TYPES_ALL OTT_ALL,
1159: oe_sold_to_orgs_v oec

Line 1205: OE_ORDER_LINES_all OEL,

1201: --OEC.customer_number
1202: PARTY.PARTY_NAME CUSTOMER_NAME,
1203: PARTY.PARTY_NUMBER CUSTOMER_NUMBER
1204: FROM
1205: OE_ORDER_LINES_all OEL,
1206: OE_ORDER_HEADERS_all OEH,
1207: OE_TRANSACTION_TYPES_TL OTT_TL,
1208: OE_TRANSACTION_TYPES_ALL OTT_ALL,
1209:

Line 1261: oe_order_lines_all oel,

1257: FROM rcv_transactions_v rtv,
1258: oe_order_headers_all oeh,
1259: OE_TRANSACTION_TYPES_TL OTT_TL,
1260: OE_TRANSACTION_TYPES_ALL OTT_ALL,
1261: oe_order_lines_all oel,
1262: -- oe_line_types_v oet,
1263: oe_sold_to_orgs_v oec
1264: WHERE oeh.header_id = rtv.oe_order_header_id
1265: AND rtv.receipt_source_code = 'CUSTOMER'

Line 1984: OE_ORDER_LINES_all OEL,

1980: NULL FIELD12,
1981: lookup_code FIELD13 ,
1982: to_char(oel.org_id) FIELD14
1983: FROM fnd_lookup_values_vl flv,
1984: OE_ORDER_LINES_all OEL,
1985: OE_ORDER_HEADERS_all OEH,
1986: --OE_LINE_TYPES_V OLT, --bug3173013
1987: OE_TRANSACTION_TYPES_TL OTT_TL,
1988: OE_TRANSACTION_TYPES_ALL OTT_ALL,

Line 2611: OE_ORDER_LINES_all OEL,

2607: NULL FIELD12,
2608: lookup_code FIELD13 ,
2609: to_char(oel.org_id) FIELD14 --
2610: FROM fnd_lookup_values_vl flv,
2611: OE_ORDER_LINES_all OEL,
2612: OE_ORDER_HEADERS_all OEH,
2613: --OE_LINE_TYPES_V OLT, --bug3173013
2614: OE_TRANSACTION_TYPES_TL OTT_TL,
2615: OE_TRANSACTION_TYPES_ALL OTT_ALL,

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

6299: WHERE organization_id = p_Organization_Id
6300: and concatenated_segments like p_concatenated_segments
6301: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
6302: and inventory_item_id IN (SELECT oel.inventory_item_id FROM
6303: oe_order_lines_all oel,oe_order_headers_all oeh--Bug 3972931-Added the table oe_order_headers_all
6304: WHERE oel.HEADER_ID = p_oeOrderHeaderID
6305: and oel.header_id = oeh.header_id --Bug4060261 -Added the join between the tables.
6306: and oel.ORDERED_QUANTITY > NVL(oel.SHIPPED_QUANTITY,0)
6307: and ((p_projectId is null or oel.project_id = p_projectId)

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

6371: ) )
6372: and mcr.inventory_item_id = msi.inventory_item_id
6373: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
6374: and msi.inventory_item_id IN (SELECT oel.inventory_item_id FROM
6375: oe_order_lines_all oel,oe_order_headers_all oeh--Bug 3972931-Added the table oe_order_headers_all
6376: WHERE oel.HEADER_ID = p_oeOrderHeaderID
6377: and oel.header_id = oeh.header_id --Bug4060261-Added the join between the tables.
6378: and oel.ORDERED_QUANTITY > NVL(oel.SHIPPED_QUANTITY,0)
6379: and ((p_projectId is null or oel.project_id = p_projectId)