APPS.ONT_OEXOEACK_XMLP_PKG dependencies on HZ_ORG_CONTACTS

Line 808: HZ_ORG_CONTACTS BILL_CT_ORG_CONT,

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
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

Line 841: HZ_ORG_CONTACTS SHIP_CT_ORG_CONT,

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
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

Line 874: HZ_ORG_CONTACTS DEL_CT_ORG_CONT,

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
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