DBA Data[Home] [Help]

APPS.INV_UI_RCV_LOVS dependencies on OE_ORDER_HEADERS_ALL

Line 1186: oe_order_headers_all oeh,

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

Line 1238: OE_ORDER_HEADERS_all OEH,

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

Line 1290: oe_order_headers_all oeh,

1286: oec.customer_id,
1287: oec.name customer_name,
1288: oec.customer_number
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,

Line 2027: OE_ORDER_HEADERS_all OEH,

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

Line 2666: OE_ORDER_HEADERS_all OEH,

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

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)