APPS.OE_VALIDATE_LINE dependencies on HZ_CUST_ACCOUNT_ROLES

Line 5337: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,

5333:
5334: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
5335: INTO l_dummy
5336: FROM
5337: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
5338: HZ_CUST_SITE_USES_ALL SITE_USE, --changed SHIP to SITE_USE for bug 3739650
5339: HZ_CUST_ACCT_SITES ADDR
5340: WHERE
5341: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_line_rec.ship_to_contact_id

Line 5431: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,

5427:
5428: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
5429: INTO l_dummy
5430: FROM
5431: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
5432: HZ_CUST_SITE_USES_ALL SITE_USE, --changed INV to SITE_USE for bug 3739650
5433: HZ_CUST_ACCT_SITES ADDR
5434: WHERE
5435: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_line_rec.deliver_to_contact_id

Line 5584: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,

5580:
5581: SELECT 'VALID'
5582: INTO l_dummy
5583: FROM
5584: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
5585: HZ_CUST_SITE_USES_ALL SITE_USE, --changed INV to SITE_USE for bug 3739650
5586: HZ_CUST_ACCT_SITES_ALL ADDR
5587: WHERE
5588: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_line_rec.invoice_to_contact_id

Line 7271: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE

7267:
7268: SELECT 'VALID'
7269: INTO l_dummy
7270: FROM
7271: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
7272: WHERE
7273: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_line_rec.end_customer_contact_id
7274: AND ACCT_ROLE.CUST_ACCOUNT_ID = p_line_rec.end_customer_id
7275: AND ROWNUM = 1