eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_VALIDATE dependencies on HZ_ROLE_RESPONSIBILITY

Line 4181: , HZ_ROLE_RESPONSIBILITY ROL

4177:
4178: SELECT 'VALID'
4179: INTO l_dummy
4180: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
4181: , HZ_ROLE_RESPONSIBILITY ROL
4182: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_ship_to_contact_id
4183: AND ACCT_ROLE.STATUS = 'A'
4184: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
4185: AND ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = ROL.CUST_ACCOUNT_ROLE_ID (+)

Line 4249: , HZ_ROLE_RESPONSIBILITY ROL

4245:
4246: SELECT 'VALID'
4247: INTO l_dummy
4248: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
4249: , HZ_ROLE_RESPONSIBILITY ROL
4250: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_intermed_ship_to_contact_id
4251: AND ACCT_ROLE.STATUS = 'A'
4252: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
4253: AND ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = ROL.CUST_ACCOUNT_ROLE_ID (+)

Line 4318: , HZ_ROLE_RESPONSIBILITY ROL

4314:
4315: SELECT 'VALID'
4316: INTO l_dummy
4317: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
4318: , HZ_ROLE_RESPONSIBILITY ROL
4319: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_invoice_to_contact_id
4320: AND ACCT_ROLE.STATUS = 'A'
4321: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
4322: AND ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = ROL.CUST_ACCOUNT_ROLE_ID (+)

Line 4380: , HZ_ROLE_RESPONSIBILITY ROL

4376:
4377: SELECT 'VALID'
4378: INTO l_dummy
4379: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
4380: , HZ_ROLE_RESPONSIBILITY ROL
4381: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_deliver_to_contact_id
4382: AND ACCT_ROLE.STATUS = 'A'
4383: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
4384: AND ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = ROL.CUST_ACCOUNT_ROLE_ID (+)