APPS.OE_VALIDATE_HEADER dependencies on HZ_CUST_ACCOUNT_ROLES

Line 1992: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE

1988:
1989: SELECT 'VALID'
1990: INTO l_dummy
1991: FROM
1992: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
1993: WHERE
1994: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.end_customer_contact_id
1995: AND ACCT_ROLE.CUST_ACCOUNT_ID = p_header_rec.end_customer_id
1996: AND ROWNUM = 1

Line 2090: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE

2086:
2087: SELECT 'VALID'
2088: INTO l_dummy
2089: FROM
2090: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
2091: WHERE
2092: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.sold_to_contact_id
2093: AND ACCT_ROLE.CUST_ACCOUNT_ID = p_header_rec.sold_to_org_id
2094: AND ROWNUM = 1

Line 2142: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,

2138:
2139: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
2140: INTO l_dummy
2141: FROM
2142: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
2143: HZ_CUST_SITE_USES_ALL SITE_USE, --changed INV to SITE_USE for bug 3739650
2144: HZ_CUST_ACCT_SITES ADDR
2145: WHERE
2146: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.invoice_to_contact_id

Line 2201: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,

2197:
2198: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
2199: INTO l_dummy
2200: FROM
2201: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
2202: HZ_CUST_SITE_USES_ALL SITE_USE, --changed SHIP to SITE_USE for bug 3739650
2203: HZ_CUST_ACCT_SITES ADDR
2204: WHERE
2205: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.ship_to_contact_id

Line 2261: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,

2257:
2258: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
2259: INTO l_dummy
2260: FROM
2261: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
2262: HZ_CUST_SITE_USES_ALL SITE_USE, --changed DELIVER to SITE_USE for bug 3739650
2263: HZ_CUST_ACCT_SITES ADDR
2264: WHERE
2265: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.deliver_to_contact_id