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_HEADERS_ALL

Line 1154: oe_order_headers_all oeh,

1150: oec.name customer_name,
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,

Line 1206: OE_ORDER_HEADERS_all OEH,

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:
1210: -- OE_LINE_TYPES_V OLT,

Line 1258: oe_order_headers_all oeh,

1254: oec.customer_id,
1255: oec.name customer_name,
1256: oec.customer_number
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,

Line 1985: OE_ORDER_HEADERS_all OEH,

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,
1989: OE_SOLD_TO_ORGS_V OESOLD,

Line 2612: OE_ORDER_HEADERS_all OEH,

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,
2616: OE_SOLD_TO_ORGS_V OESOLD,

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)