APPS.OE_CNCL_VALIDATE dependencies on OE_SOLD_TO_ORGS_V

Line 440: FROM OE_SOLD_TO_ORGS_V

436: END IF;
437:
438: SELECT 'VALID'
439: INTO l_dummy
440: FROM OE_SOLD_TO_ORGS_V
441: WHERE ORGANIZATION_ID =p_end_customer_id
442: AND STATUS = 'A'
443: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
444: AND NVL(END_DATE_ACTIVE, SYSDATE);

Line 3124: FROM OE_SOLD_TO_ORGS_V

3120: END IF;
3121:
3122: SELECT 'VALID'
3123: INTO l_dummy
3124: FROM OE_SOLD_TO_ORGS_V
3125: WHERE ORGANIZATION_ID =p_sold_to_org_id
3126: AND ROWNUM = 1;
3127: --
3128: -- Commented out when importing CLOSED orders

Line 3189: FROM OE_SOLD_TO_ORGS_V

3185: END IF;
3186:
3187: SELECT 'VALID'
3188: INTO l_dummy
3189: FROM OE_SOLD_TO_ORGS_V
3190: WHERE ORGANIZATION_ID =p_customer_id
3191: AND ROWNUM = 1;
3192: --
3193: -- Commented out when importing CLOSED orders