APPS.INV_UI_RCV_LOVS dependencies on OE_TRANSACTION_TYPES_TL

Line 1189: OE_TRANSACTION_TYPES_TL OTT_TL,

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,
1191: oe_sold_to_orgs_v oec
1192: WHERE oeh.header_id = rt.oe_order_header_id
1193: -- AND oet.order_category_code = 'RETURN'

Line 1239: OE_TRANSACTION_TYPES_TL OTT_TL,

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

Line 1291: OE_TRANSACTION_TYPES_TL OTT_TL,

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,
1295: oe_sold_to_orgs_v oec

Line 2029: OE_TRANSACTION_TYPES_TL OTT_TL,

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

Line 2668: OE_TRANSACTION_TYPES_TL OTT_TL,

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,
2671: --WF_ITEM_ACTIVITY_STATUSES WF,
2672: --WF_PROCESS_ACTIVITIES WPA,