DBA Data[Home] [Help]

APPS.INV_UI_RCV_LOVS dependencies on OE_TRANSACTION_TYPES_ALL

Line 1158: OE_TRANSACTION_TYPES_ALL OTT_ALL,

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
1160: WHERE oeh.header_id = rt.oe_order_header_id
1161: -- AND oet.order_category_code = 'RETURN'
1162: AND rt.source_document_code = 'RMA'

Line 1208: OE_TRANSACTION_TYPES_ALL OTT_ALL,

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,
1211: OE_SOLD_TO_ORGS_V OESOLD,
1212: WF_ITEM_ACTIVITY_STATUSES WF,

Line 1260: OE_TRANSACTION_TYPES_ALL OTT_ALL,

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

Line 1988: OE_TRANSACTION_TYPES_ALL OTT_ALL,

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,
1990: --WF_ITEM_ACTIVITY_STATUSES WF,
1991: --WF_PROCESS_ACTIVITIES WPA,
1992: --RA_CUSTOMERS OEC

Line 2615: OE_TRANSACTION_TYPES_ALL OTT_ALL,

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,
2617: --WF_ITEM_ACTIVITY_STATUSES WF,
2618: --WF_PROCESS_ACTIVITIES WPA,
2619: --RA_CUSTOMERS OEC /*TCA Cleanup */