APPS.OE_CNCL_VALIDATE_HEADER dependencies on HZ_CUST_ACCOUNT_ROLES

Line 992: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE

988: BEGIN
989:
990: SELECT 'VALID'
991: INTO l_dummy
992: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
993: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.sold_to_contact_id
994: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
995: AND ACCT_ROLE.CUST_ACCOUNT_ID = p_header_rec.sold_to_org_id
996: AND ROWNUM = 1;

Line 1038: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE

1034: ('inv_to_contact :'||to_char(p_header_rec.invoice_to_contact_id),2);
1035:
1036: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
1037: INTO l_dummy
1038: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
1039: , HZ_CUST_ACCT_SITES ACCT_SITE
1040: , HZ_CUST_SITE_USES_ALL INV
1041: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.invoice_to_contact_id
1042: AND ACCT_ROLE.CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID

Line 1089: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE

1085: BEGIN
1086:
1087: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
1088: INTO l_dummy
1089: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
1090: , HZ_CUST_ACCT_SITES ACCT_SITE
1091: , HZ_CUST_SITE_USES_ALL SHIP
1092: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.ship_to_contact_id
1093: AND ACCT_ROLE.CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID

Line 1144: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE

1140: BEGIN
1141:
1142: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
1143: INTO l_dummy
1144: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
1145: , HZ_CUST_ACCT_SITES ACCT_SITE
1146: , HZ_CUST_SITE_USES_ALL DELIVER
1147: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.deliver_to_contact_id
1148: AND ACCT_ROLE.CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID