APPS.INV_UI_RCV_LOVS dependencies on OE_SOLD_TO_ORGS_V

Line 1159: oe_sold_to_orgs_v oec

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'
1163: AND rt.oe_order_header_id = ms.oe_order_header_id

Line 1211: OE_SOLD_TO_ORGS_V OESOLD,

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,
1213: WF_PROCESS_ACTIVITIES WPA,
1214: --RA_CUSTOMERS OEC /*TCA Cleanup */
1215: HZ_PARTIES PARTY,

Line 1263: oe_sold_to_orgs_v oec

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
1265: AND rtv.receipt_source_code = 'CUSTOMER'
1266: AND rtv.to_organization_id = p_organization_id
1267: AND rtv.inspection_status_code = 'NOT INSPECTED'

Line 1989: OE_SOLD_TO_ORGS_V OESOLD,

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
1993: HZ_PARTIES PARTY,

Line 2616: OE_SOLD_TO_ORGS_V OESOLD,

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 */
2620: HZ_PARTIES PARTY,