APPS.ECE_AR_TRANSACTION dependencies on HZ_PARTIES

Line 4080: HZ_PARTIES PARTY,

4076: ORG_CONT.JOB_TITLE
4077: into l_bill_to_contact_last_name,l_bill_to_contact_first_name,l_bill_to_contact_job_title
4078: FROM
4079: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
4080: HZ_PARTIES PARTY,
4081: HZ_RELATIONSHIPS REL,
4082: HZ_ORG_CONTACTS ORG_CONT
4083: WHERE
4084: ACCT_ROLE.PARTY_ID = REL.PARTY_ID

Line 4088: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

4084: ACCT_ROLE.PARTY_ID = REL.PARTY_ID
4085: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
4086: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
4087: AND REL.DIRECTIONAL_FLAG = 'F'
4088: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4089: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4090: AND REL.SUBJECT_ID = PARTY.PARTY_ID
4091: AND ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = l_bill_to_contact_id;
4092: /* select last_name,first_name,job_title

Line 4089: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

4085: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
4086: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
4087: AND REL.DIRECTIONAL_FLAG = 'F'
4088: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4089: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4090: AND REL.SUBJECT_ID = PARTY.PARTY_ID
4091: AND ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = l_bill_to_contact_id;
4092: /* select last_name,first_name,job_title
4093: into l_bill_to_contact_last_name,l_bill_to_contact_first_name,l_bill_to_contact_job_title

Line 4112: HZ_PARTIES PARTY,

4108: ORG_CONT.JOB_TITLE
4109: into l_ship_to_contact_last_name,l_ship_to_contact_first_name,l_ship_to_contact_job_title
4110: FROM
4111: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
4112: HZ_PARTIES PARTY,
4113: HZ_RELATIONSHIPS REL,
4114: HZ_ORG_CONTACTS ORG_CONT,
4115: HZ_PARTIES REL_PARTY
4116: WHERE

Line 4115: HZ_PARTIES REL_PARTY

4111: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
4112: HZ_PARTIES PARTY,
4113: HZ_RELATIONSHIPS REL,
4114: HZ_ORG_CONTACTS ORG_CONT,
4115: HZ_PARTIES REL_PARTY
4116: WHERE
4117: ACCT_ROLE.PARTY_ID = REL.PARTY_ID
4118: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
4119: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID

Line 4121: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

4117: ACCT_ROLE.PARTY_ID = REL.PARTY_ID
4118: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
4119: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
4120: AND REL.DIRECTIONAL_FLAG = 'F'
4121: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4122: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4123: AND REL.SUBJECT_ID = PARTY.PARTY_ID
4124: AND REL.PARTY_ID = REL_PARTY.PARTY_ID
4125: AND ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = l_ship_to_contact_id;

Line 4122: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

4118: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
4119: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
4120: AND REL.DIRECTIONAL_FLAG = 'F'
4121: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4122: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4123: AND REL.SUBJECT_ID = PARTY.PARTY_ID
4124: AND REL.PARTY_ID = REL_PARTY.PARTY_ID
4125: AND ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = l_ship_to_contact_id;
4126: /*

Line 4147: HZ_PARTIES PARTY,

4143: ORG_CONT.JOB_TITLE
4144: into l_sold_to_contact_last_name,l_sold_to_contact_first_name,l_sold_to_contact_job_title
4145: FROM
4146: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
4147: HZ_PARTIES PARTY,
4148: HZ_RELATIONSHIPS REL,
4149: HZ_ORG_CONTACTS ORG_CONT,
4150: HZ_PARTIES REL_PARTY
4151: WHERE

Line 4150: HZ_PARTIES REL_PARTY

4146: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
4147: HZ_PARTIES PARTY,
4148: HZ_RELATIONSHIPS REL,
4149: HZ_ORG_CONTACTS ORG_CONT,
4150: HZ_PARTIES REL_PARTY
4151: WHERE
4152: ACCT_ROLE.PARTY_ID = REL.PARTY_ID
4153: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
4154: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID

Line 4156: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

4152: ACCT_ROLE.PARTY_ID = REL.PARTY_ID
4153: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
4154: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
4155: AND REL.DIRECTIONAL_FLAG = 'F'
4156: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4157: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4158: AND REL.SUBJECT_ID = PARTY.PARTY_ID
4159: AND REL.PARTY_ID = REL_PARTY.PARTY_ID
4160: AND ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = l_sold_to_contact_id;

Line 4157: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

4153: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
4154: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
4155: AND REL.DIRECTIONAL_FLAG = 'F'
4156: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4157: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4158: AND REL.SUBJECT_ID = PARTY.PARTY_ID
4159: AND REL.PARTY_ID = REL_PARTY.PARTY_ID
4160: AND ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = l_sold_to_contact_id;
4161: /* select last_name,first_name,job_title