APPS.OE_CNCL_VALIDATE_HEADER dependencies on HZ_CUST_ACCOUNT_ROLES

Line 1023: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE

1019: BEGIN
1020:
1021: SELECT 'VALID'
1022: INTO l_dummy
1023: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
1024: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.sold_to_contact_id
1025: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
1026: AND ACCT_ROLE.CUST_ACCOUNT_ID = p_header_rec.sold_to_org_id
1027: AND ROWNUM = 1;

Line 1069: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE

1065: ('inv_to_contact :'||to_char(p_header_rec.invoice_to_contact_id),2);
1066:
1067: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
1068: INTO l_dummy
1069: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
1070: , HZ_CUST_ACCT_SITES ACCT_SITE
1071: , HZ_CUST_SITE_USES_ALL INV
1072: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.invoice_to_contact_id
1073: AND ACCT_ROLE.CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID

Line 1120: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE

1116: BEGIN
1117:
1118: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
1119: INTO l_dummy
1120: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
1121: , HZ_CUST_ACCT_SITES ACCT_SITE
1122: , HZ_CUST_SITE_USES_ALL SHIP
1123: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.ship_to_contact_id
1124: AND ACCT_ROLE.CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID

Line 1175: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE

1171: BEGIN
1172:
1173: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
1174: INTO l_dummy
1175: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
1176: , HZ_CUST_ACCT_SITES ACCT_SITE
1177: , HZ_CUST_SITE_USES_ALL DELIVER
1178: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.deliver_to_contact_id
1179: AND ACCT_ROLE.CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID