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 806: HZ_PARTIES BILL_CT_PARTY,

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

Line 809: HZ_PARTIES BILL_CT_REL_PARTY,

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

Line 817: AND BILL_CT_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

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

Line 818: AND BILL_CT_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

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

Line 839: HZ_PARTIES SHIP_CT_PARTY,

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

Line 842: HZ_PARTIES SHIP_CT_REL_PARTY,

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

Line 850: AND SHIP_CT_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

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

Line 851: AND SHIP_CT_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

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

Line 872: HZ_PARTIES DEL_CT_PARTY,

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

Line 875: HZ_PARTIES DEL_CT_REL_PARTY,

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

Line 883: AND DEL_CT_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

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

Line 884: AND DEL_CT_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

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