APPS.OE_CNCL_VALIDATE dependencies on OE_RA_CONTACT_ROLES_V

Line 3890: , OE_RA_CONTACT_ROLES_V ROL

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'
3894: AND ROWNUM = 1;

Line 3957: , OE_RA_CONTACT_ROLES_V ROL

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'
3961: AND ROWNUM = 1;

Line 4024: , OE_RA_CONTACT_ROLES_V ROL

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'
4028: AND ROWNUM = 1;

Line 4088: , OE_RA_CONTACT_ROLES_V ROL

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'
4092: AND ROWNUM = 1;