APPS.OE_VALIDATE_HEADER dependencies on HZ_CUST_ACCOUNT_ROLES

Line 1923: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE

1919:
1920: SELECT 'VALID'
1921: INTO l_dummy
1922: FROM
1923: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
1924: WHERE
1925: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.end_customer_contact_id
1926: AND ACCT_ROLE.CUST_ACCOUNT_ID = p_header_rec.end_customer_id
1927: AND ROWNUM = 1

Line 2021: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE

2017:
2018: SELECT 'VALID'
2019: INTO l_dummy
2020: FROM
2021: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
2022: WHERE
2023: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.sold_to_contact_id
2024: AND ACCT_ROLE.CUST_ACCOUNT_ID = p_header_rec.sold_to_org_id
2025: AND ROWNUM = 1

Line 2073: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,

2069:
2070: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
2071: INTO l_dummy
2072: FROM
2073: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
2074: HZ_CUST_SITE_USES_ALL SITE_USE, --changed INV to SITE_USE for bug 3739650
2075: HZ_CUST_ACCT_SITES ADDR
2076: WHERE
2077: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.invoice_to_contact_id

Line 2132: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,

2128:
2129: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
2130: INTO l_dummy
2131: FROM
2132: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
2133: HZ_CUST_SITE_USES_ALL SITE_USE, --changed SHIP to SITE_USE for bug 3739650
2134: HZ_CUST_ACCT_SITES ADDR
2135: WHERE
2136: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.ship_to_contact_id

Line 2192: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,

2188:
2189: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
2190: INTO l_dummy
2191: FROM
2192: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
2193: HZ_CUST_SITE_USES_ALL SITE_USE, --changed DELIVER to SITE_USE for bug 3739650
2194: HZ_CUST_ACCT_SITES ADDR
2195: WHERE
2196: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.deliver_to_contact_id