APPS.INV_UI_RCV_LOVS dependencies on OE_TRANSACTION_TYPES_TL

Line 1157: OE_TRANSACTION_TYPES_TL OTT_TL,

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

Line 1207: OE_TRANSACTION_TYPES_TL OTT_TL,

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

Line 1259: OE_TRANSACTION_TYPES_TL OTT_TL,

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

Line 1987: OE_TRANSACTION_TYPES_TL OTT_TL,

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

Line 2614: OE_TRANSACTION_TYPES_TL OTT_TL,

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,
2617: --WF_ITEM_ACTIVITY_STATUSES WF,
2618: --WF_PROCESS_ACTIVITIES WPA,