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.ONT_OEXOEACK_XMLP_PKG dependencies on HZ_PARTIES

Line 807: HZ_PARTIES BILL_CT_PARTY,

803: ,50)
804: INTO L_BILL_CONTACT
805: FROM
806: HZ_CUST_ACCOUNT_ROLES BILL_CT_ACCT_ROLE,
807: HZ_PARTIES BILL_CT_PARTY,
808: HZ_RELATIONSHIPS BILL_CT_REL,
809: HZ_ORG_CONTACTS BILL_CT_ORG_CONT,
810: HZ_PARTIES BILL_CT_REL_PARTY,
811: HZ_CUST_ACCOUNTS BILL_CT_ROLE_ACCT

Line 810: HZ_PARTIES BILL_CT_REL_PARTY,

806: HZ_CUST_ACCOUNT_ROLES BILL_CT_ACCT_ROLE,
807: HZ_PARTIES BILL_CT_PARTY,
808: HZ_RELATIONSHIPS BILL_CT_REL,
809: HZ_ORG_CONTACTS BILL_CT_ORG_CONT,
810: HZ_PARTIES BILL_CT_REL_PARTY,
811: HZ_CUST_ACCOUNTS BILL_CT_ROLE_ACCT
812: WHERE BILL_CT_ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = INVOICE_TO_CONTACT_ID
813: AND BILL_CT_ACCT_ROLE.PARTY_ID = BILL_CT_REL.PARTY_ID
814: AND BILL_CT_ACCT_ROLE.ROLE_TYPE = 'CONTACT'

Line 818: AND BILL_CT_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

814: AND BILL_CT_ACCT_ROLE.ROLE_TYPE = 'CONTACT'
815: AND BILL_CT_REL.RELATIONSHIP_ID = BILL_CT_ORG_CONT.PARTY_RELATIONSHIP_ID
816: AND BILL_CT_REL.SUBJECT_ID = BILL_CT_PARTY.PARTY_ID
817: AND BILL_CT_REL.PARTY_ID = BILL_CT_REL_PARTY.PARTY_ID
818: AND BILL_CT_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
819: AND BILL_CT_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
820: AND BILL_CT_ACCT_ROLE.CUST_ACCOUNT_ID = BILL_CT_ROLE_ACCT.CUST_ACCOUNT_ID
821: AND BILL_CT_ROLE_ACCT.PARTY_ID = BILL_CT_REL.OBJECT_ID;
822: RETURN (L_BILL_CONTACT);

Line 819: AND BILL_CT_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

815: AND BILL_CT_REL.RELATIONSHIP_ID = BILL_CT_ORG_CONT.PARTY_RELATIONSHIP_ID
816: AND BILL_CT_REL.SUBJECT_ID = BILL_CT_PARTY.PARTY_ID
817: AND BILL_CT_REL.PARTY_ID = BILL_CT_REL_PARTY.PARTY_ID
818: AND BILL_CT_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
819: AND BILL_CT_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
820: AND BILL_CT_ACCT_ROLE.CUST_ACCOUNT_ID = BILL_CT_ROLE_ACCT.CUST_ACCOUNT_ID
821: AND BILL_CT_ROLE_ACCT.PARTY_ID = BILL_CT_REL.OBJECT_ID;
822: RETURN (L_BILL_CONTACT);
823: EXCEPTION

Line 840: HZ_PARTIES SHIP_CT_PARTY,

836: ,50)
837: INTO L_SHIP_CONTACT
838: FROM
839: HZ_CUST_ACCOUNT_ROLES SHIP_CT_ACCT_ROLE,
840: HZ_PARTIES SHIP_CT_PARTY,
841: HZ_RELATIONSHIPS SHIP_CT_REL,
842: HZ_ORG_CONTACTS SHIP_CT_ORG_CONT,
843: HZ_PARTIES SHIP_CT_REL_PARTY,
844: HZ_CUST_ACCOUNTS SHIP_CT_ROLE_ACCT

Line 843: HZ_PARTIES SHIP_CT_REL_PARTY,

839: HZ_CUST_ACCOUNT_ROLES SHIP_CT_ACCT_ROLE,
840: HZ_PARTIES SHIP_CT_PARTY,
841: HZ_RELATIONSHIPS SHIP_CT_REL,
842: HZ_ORG_CONTACTS SHIP_CT_ORG_CONT,
843: HZ_PARTIES SHIP_CT_REL_PARTY,
844: HZ_CUST_ACCOUNTS SHIP_CT_ROLE_ACCT
845: WHERE SHIP_CT_ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = SHIP_TO_CONTACT_ID
846: AND SHIP_CT_ACCT_ROLE.PARTY_ID = SHIP_CT_REL.PARTY_ID
847: AND SHIP_CT_ACCT_ROLE.ROLE_TYPE = 'CONTACT'

Line 851: AND SHIP_CT_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

847: AND SHIP_CT_ACCT_ROLE.ROLE_TYPE = 'CONTACT'
848: AND SHIP_CT_REL.RELATIONSHIP_ID = SHIP_CT_ORG_CONT.PARTY_RELATIONSHIP_ID
849: AND SHIP_CT_REL.SUBJECT_ID = SHIP_CT_PARTY.PARTY_ID
850: AND SHIP_CT_REL.PARTY_ID = SHIP_CT_REL_PARTY.PARTY_ID
851: AND SHIP_CT_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
852: AND SHIP_CT_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
853: AND SHIP_CT_ACCT_ROLE.CUST_ACCOUNT_ID = SHIP_CT_ROLE_ACCT.CUST_ACCOUNT_ID
854: AND SHIP_CT_ROLE_ACCT.PARTY_ID = SHIP_CT_REL.OBJECT_ID;
855: RETURN (L_SHIP_CONTACT);

Line 852: AND SHIP_CT_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

848: AND SHIP_CT_REL.RELATIONSHIP_ID = SHIP_CT_ORG_CONT.PARTY_RELATIONSHIP_ID
849: AND SHIP_CT_REL.SUBJECT_ID = SHIP_CT_PARTY.PARTY_ID
850: AND SHIP_CT_REL.PARTY_ID = SHIP_CT_REL_PARTY.PARTY_ID
851: AND SHIP_CT_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
852: AND SHIP_CT_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
853: AND SHIP_CT_ACCT_ROLE.CUST_ACCOUNT_ID = SHIP_CT_ROLE_ACCT.CUST_ACCOUNT_ID
854: AND SHIP_CT_ROLE_ACCT.PARTY_ID = SHIP_CT_REL.OBJECT_ID;
855: RETURN (L_SHIP_CONTACT);
856: EXCEPTION

Line 873: HZ_PARTIES DEL_CT_PARTY,

869: ,50)
870: INTO L_DEL_CONTACT
871: FROM
872: HZ_CUST_ACCOUNT_ROLES DEL_CT_ACCT_ROLE,
873: HZ_PARTIES DEL_CT_PARTY,
874: HZ_RELATIONSHIPS DEL_CT_REL,
875: HZ_ORG_CONTACTS DEL_CT_ORG_CONT,
876: HZ_PARTIES DEL_CT_REL_PARTY,
877: HZ_CUST_ACCOUNTS DEL_CT_ROLE_ACCT

Line 876: HZ_PARTIES DEL_CT_REL_PARTY,

872: HZ_CUST_ACCOUNT_ROLES DEL_CT_ACCT_ROLE,
873: HZ_PARTIES DEL_CT_PARTY,
874: HZ_RELATIONSHIPS DEL_CT_REL,
875: HZ_ORG_CONTACTS DEL_CT_ORG_CONT,
876: HZ_PARTIES DEL_CT_REL_PARTY,
877: HZ_CUST_ACCOUNTS DEL_CT_ROLE_ACCT
878: WHERE DEL_CT_ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = DELIVER_TO_CONTACT_ID
879: AND DEL_CT_ACCT_ROLE.PARTY_ID = DEL_CT_REL.PARTY_ID
880: AND DEL_CT_ACCT_ROLE.ROLE_TYPE = 'CONTACT'

Line 884: AND DEL_CT_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

880: AND DEL_CT_ACCT_ROLE.ROLE_TYPE = 'CONTACT'
881: AND DEL_CT_REL.RELATIONSHIP_ID = DEL_CT_ORG_CONT.PARTY_RELATIONSHIP_ID
882: AND DEL_CT_REL.SUBJECT_ID = DEL_CT_PARTY.PARTY_ID
883: AND DEL_CT_REL.PARTY_ID = DEL_CT_REL_PARTY.PARTY_ID
884: AND DEL_CT_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
885: AND DEL_CT_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
886: AND DEL_CT_ACCT_ROLE.CUST_ACCOUNT_ID = DEL_CT_ROLE_ACCT.CUST_ACCOUNT_ID
887: AND DEL_CT_ROLE_ACCT.PARTY_ID = DEL_CT_REL.OBJECT_ID;
888: RETURN (L_DEL_CONTACT);

Line 885: AND DEL_CT_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

881: AND DEL_CT_REL.RELATIONSHIP_ID = DEL_CT_ORG_CONT.PARTY_RELATIONSHIP_ID
882: AND DEL_CT_REL.SUBJECT_ID = DEL_CT_PARTY.PARTY_ID
883: AND DEL_CT_REL.PARTY_ID = DEL_CT_REL_PARTY.PARTY_ID
884: AND DEL_CT_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
885: AND DEL_CT_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
886: AND DEL_CT_ACCT_ROLE.CUST_ACCOUNT_ID = DEL_CT_ROLE_ACCT.CUST_ACCOUNT_ID
887: AND DEL_CT_ROLE_ACCT.PARTY_ID = DEL_CT_REL.OBJECT_ID;
888: RETURN (L_DEL_CONTACT);
889: EXCEPTION