APPS.OE_CNCL_VALIDATE dependencies on OE_RA_CONTACTS_V

Line 501: FROM OE_RA_CONTACTS_V CON

497:
498:
499: SELECT 'VALID'
500: INTO l_dummy
501: FROM OE_RA_CONTACTS_V CON
502: WHERE CON.CONTACT_ID = p_end_customer_contact_id
503: AND CON.STATUS = 'A';
504:
505: RETURN TRUE;

Line 3826: FROM OE_RA_CONTACTS_V

3822: END IF;
3823:
3824: SELECT 'VALID'
3825: INTO l_dummy
3826: FROM OE_RA_CONTACTS_V
3827: WHERE CONTACT_ID = p_sold_to_contact_id
3828: AND ROWNUM = 1;
3829: --
3830: -- Commented out when importing CLOSED orders

Line 3889: FROM OE_RA_CONTACTS_V CON

3885: END IF;
3886:
3887: SELECT 'VALID'
3888: INTO l_dummy
3889: FROM OE_RA_CONTACTS_V CON
3890: , OE_RA_CONTACT_ROLES_V ROL
3891: WHERE CON.CONTACT_ID = p_ship_to_contact_id
3892: AND CON.CONTACT_ID = ROL.CONTACT_ID (+)
3893: AND NVL( ROL.USAGE_CODE,'SHIP_TO')='SHIP_TO'

Line 3956: FROM OE_RA_CONTACTS_V CON

3952: END IF;
3953:
3954: SELECT 'VALID'
3955: INTO l_dummy
3956: FROM OE_RA_CONTACTS_V CON
3957: , OE_RA_CONTACT_ROLES_V ROL
3958: WHERE CON.CONTACT_ID = p_intermed_ship_to_contact_id
3959: AND CON.CONTACT_ID = ROL.CONTACT_ID (+)
3960: AND NVL( ROL.USAGE_CODE,'SHIP_TO')='SHIP_TO'

Line 4023: FROM OE_RA_CONTACTS_V CON

4019: END IF;
4020:
4021: SELECT 'VALID'
4022: INTO l_dummy
4023: FROM OE_RA_CONTACTS_V CON
4024: , OE_RA_CONTACT_ROLES_V ROL
4025: WHERE CON.CONTACT_ID = p_invoice_to_contact_id
4026: AND CON.CONTACT_ID = ROL.CONTACT_ID (+)
4027: AND NVL( ROL.USAGE_CODE,'BILL_TO')='BILL_TO'

Line 4087: FROM OE_RA_CONTACTS_V CON

4083: END IF;
4084:
4085: SELECT 'VALID'
4086: INTO l_dummy
4087: FROM OE_RA_CONTACTS_V CON
4088: , OE_RA_CONTACT_ROLES_V ROL
4089: WHERE CON.CONTACT_ID = p_deliver_to_contact_id
4090: AND CON.CONTACT_ID = ROL.CONTACT_ID (+)
4091: AND NVL( ROL.USAGE_CODE,'SHIP_TO')='SHIP_TO'