APPS.OE_VALIDATE dependencies on OE_SOLD_TO_ORGS_V

Line 3360: FROM OE_SOLD_TO_ORGS_V

3356: END IF;
3357:
3358: SELECT 'VALID'
3359: INTO l_dummy
3360: FROM OE_SOLD_TO_ORGS_V
3361: WHERE ORGANIZATION_ID =p_sold_to_org_id
3362: AND STATUS = 'A'
3363: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
3364: AND NVL(END_DATE_ACTIVE, SYSDATE);

Line 3479: FROM OE_SOLD_TO_ORGS_V

3475: END IF;
3476:
3477: SELECT 'VALID'
3478: INTO l_dummy
3479: FROM OE_SOLD_TO_ORGS_V
3480: WHERE ORGANIZATION_ID =p_customer_id
3481: AND STATUS = 'A'
3482: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
3483: AND NVL(END_DATE_ACTIVE, SYSDATE);

Line 22305: FROM OE_SOLD_TO_ORGS_V

22301: END IF;
22302:
22303: SELECT 'VALID'
22304: INTO l_dummy
22305: FROM OE_SOLD_TO_ORGS_V
22306: WHERE ORGANIZATION_ID =p_end_customer_id
22307: AND STATUS = 'A'
22308: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
22309: AND NVL(END_DATE_ACTIVE, SYSDATE);