APPS.INV_UI_RCV_LOVS dependencies on OE_SOLD_TO_ORGS_V

Line 1191: oe_sold_to_orgs_v oec

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

Line 1243: OE_SOLD_TO_ORGS_V OESOLD,

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,
1245: WF_PROCESS_ACTIVITIES WPA,
1246: --RA_CUSTOMERS OEC /*TCA Cleanup */
1247: HZ_PARTIES PARTY,

Line 1295: oe_sold_to_orgs_v oec

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
1297: AND rtv.receipt_source_code = 'CUSTOMER'
1298: AND rtv.to_organization_id = p_organization_id
1299: AND rtv.inspection_status_code = 'NOT INSPECTED'

Line 2031: OE_SOLD_TO_ORGS_V OESOLD,

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

Line 2670: OE_SOLD_TO_ORGS_V OESOLD,

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