APPS.OE_BULK_VALIDATE dependencies on OE_SOLD_TO_ORGS_V

Line 1173: FROM OE_SOLD_TO_ORGS_V

1169: FROM OE_HEADERS_IFACE_ALL b
1170: WHERE batch_id = p_batch_id and
1171: b.sold_to_org_id IS NOT NULL and
1172: NOT EXISTS (select ORGANIZATION_ID
1173: FROM OE_SOLD_TO_ORGS_V
1174: WHERE ORGANIZATION_ID = b.sold_to_org_id
1175: AND STATUS = 'A'
1176: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
1177: AND NVL(END_DATE_ACTIVE, SYSDATE))

Line 1213: FROM OE_SOLD_TO_ORGS_V

1209: FROM OE_HEADERS_IFACE_ALL
1210: WHERE batch_id = p_batch_id)
1211: AND b.sold_to_org_id IS NOT NULL and
1212: NOT EXISTS (select ORGANIZATION_ID
1213: FROM OE_SOLD_TO_ORGS_V
1214: WHERE ORGANIZATION_ID = b.sold_to_org_id
1215: AND STATUS = 'A'
1216: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
1217: AND NVL(END_DATE_ACTIVE, SYSDATE));

Line 2204: FROM OE_SOLD_TO_ORGS_V

2200: FROM OE_HEADERS_IFACE_ALL b
2201: WHERE batch_id = p_batch_id and
2202: b.sold_to_org_id IS NOT NULL and
2203: NOT EXISTS (select ORGANIZATION_ID
2204: FROM OE_SOLD_TO_ORGS_V
2205: WHERE ORGANIZATION_ID = b.sold_to_org_id
2206: AND STATUS = 'A'
2207: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
2208: AND NVL(END_DATE_ACTIVE, SYSDATE))

Line 2244: FROM OE_SOLD_TO_ORGS_V

2240: FROM OE_HEADERS_IFACE_ALL
2241: WHERE batch_id = p_batch_id)
2242: AND b.sold_to_org_id IS NOT NULL and
2243: NOT EXISTS (select ORGANIZATION_ID
2244: FROM OE_SOLD_TO_ORGS_V
2245: WHERE ORGANIZATION_ID = b.sold_to_org_id
2246: AND STATUS = 'A'
2247: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
2248: AND NVL(END_DATE_ACTIVE, SYSDATE));