APPS.OE_VALIDATE_LINE dependencies on HZ_CUST_ACCOUNT_ROLES

Line 5678: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,

5674:
5675: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
5676: INTO l_dummy
5677: FROM
5678: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
5679: HZ_CUST_SITE_USES_ALL SITE_USE, --changed SHIP to SITE_USE for bug 3739650
5680: HZ_CUST_ACCT_SITES ADDR
5681: WHERE
5682: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_line_rec.ship_to_contact_id

Line 5772: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,

5768:
5769: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
5770: INTO l_dummy
5771: FROM
5772: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
5773: HZ_CUST_SITE_USES_ALL SITE_USE, --changed INV to SITE_USE for bug 3739650
5774: HZ_CUST_ACCT_SITES ADDR
5775: WHERE
5776: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_line_rec.deliver_to_contact_id

Line 5925: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,

5921:
5922: SELECT 'VALID'
5923: INTO l_dummy
5924: FROM
5925: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
5926: HZ_CUST_SITE_USES_ALL SITE_USE, --changed INV to SITE_USE for bug 3739650
5927: HZ_CUST_ACCT_SITES_ALL ADDR
5928: WHERE
5929: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_line_rec.invoice_to_contact_id

Line 7669: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE

7665:
7666: SELECT 'VALID'
7667: INTO l_dummy
7668: FROM
7669: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
7670: WHERE
7671: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_line_rec.end_customer_contact_id
7672: AND ACCT_ROLE.CUST_ACCOUNT_ID = p_line_rec.end_customer_id
7673: AND ROWNUM = 1