DBA Data[Home] [Help]

APPS.INV_UI_RCV_LOVS dependencies on OE_TRANSACTION_TYPES_ALL

Line 1190: OE_TRANSACTION_TYPES_ALL OTT_ALL,

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
1192: WHERE oeh.header_id = rt.oe_order_header_id
1193: -- AND oet.order_category_code = 'RETURN'
1194: AND rt.source_document_code = 'RMA'

Line 1240: OE_TRANSACTION_TYPES_ALL OTT_ALL,

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,
1243: OE_SOLD_TO_ORGS_V OESOLD,
1244: WF_ITEM_ACTIVITY_STATUSES WF,

Line 1292: OE_TRANSACTION_TYPES_ALL OTT_ALL,

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,
1295: oe_sold_to_orgs_v oec
1296: WHERE oeh.header_id = rtv.oe_order_header_id

Line 2030: OE_TRANSACTION_TYPES_ALL OTT_ALL,

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,
2032: --WF_ITEM_ACTIVITY_STATUSES WF,
2033: --WF_PROCESS_ACTIVITIES WPA,
2034: --RA_CUSTOMERS OEC

Line 2669: OE_TRANSACTION_TYPES_ALL OTT_ALL,

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,
2671: --WF_ITEM_ACTIVITY_STATUSES WF,
2672: --WF_PROCESS_ACTIVITIES WPA,
2673: --RA_CUSTOMERS OEC /*TCA Cleanup */