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

Line 621: hz_parties party

617: WHERE gt.ship_to_customer_name IS NOT NULL
618: AND NOT EXISTS
619: (SELECT 'X'
620: FROM hz_cust_accounts cust_acct,
621: hz_parties party
622: WHERE cust_acct.party_id = party.party_id
623: AND party.party_name = gt.ship_to_customer_name);
624:
625: IF pg_debug = 'Y' THEN

Line 703: hz_parties party

699: WHERE gt.bill_to_customer_name IS NOT NULL
700: AND NOT EXISTS
701: (SELECT 'X'
702: FROM hz_cust_accounts cust_acct,
703: hz_parties party
704: WHERE cust_acct.party_id = party.party_id
705: AND party.party_name = gt.bill_to_customer_name);
706:
707: IF pg_debug = 'Y' THEN

Line 785: hz_parties party,

781: WHERE gt.bill_to_contact_id IS NOT NULL
782: AND NOT EXISTS
783: (SELECT 'X'
784: FROM hz_cust_account_roles acct_role,
785: hz_parties party,
786: hz_relationships rel,
787: hz_org_contacts org_cont,
788: hz_parties rel_party
789: WHERE acct_role.party_id = rel.party_id

Line 788: hz_parties rel_party

784: FROM hz_cust_account_roles acct_role,
785: hz_parties party,
786: hz_relationships rel,
787: hz_org_contacts org_cont,
788: hz_parties rel_party
789: WHERE acct_role.party_id = rel.party_id
790: AND acct_role.role_type = 'CONTACT'
791: and org_cont.party_relationship_id = rel.relationship_id
792: and rel.subject_id = party.party_id

Line 794: and rel.subject_table_name = 'HZ_PARTIES'

790: AND acct_role.role_type = 'CONTACT'
791: and org_cont.party_relationship_id = rel.relationship_id
792: and rel.subject_id = party.party_id
793: and rel.party_id = rel_party.party_id
794: and rel.subject_table_name = 'HZ_PARTIES'
795: and rel.object_table_name = 'HZ_PARTIES'
796: and rel.directional_flag = 'F'
797: and acct_role.cust_account_id = gt.bill_to_customer_id
798: and ( acct_role.cust_acct_site_id = gt.bill_to_address_id

Line 795: and rel.object_table_name = 'HZ_PARTIES'

791: and org_cont.party_relationship_id = rel.relationship_id
792: and rel.subject_id = party.party_id
793: and rel.party_id = rel_party.party_id
794: and rel.subject_table_name = 'HZ_PARTIES'
795: and rel.object_table_name = 'HZ_PARTIES'
796: and rel.directional_flag = 'F'
797: and acct_role.cust_account_id = gt.bill_to_customer_id
798: and ( acct_role.cust_acct_site_id = gt.bill_to_address_id
799: or acct_role.cust_acct_site_id IS NULL )

Line 840: hz_parties party,

836: WHERE gt.ship_to_contact_id IS NOT NULL
837: AND NOT EXISTS
838: (SELECT 'X'
839: FROM hz_cust_account_roles acct_role,
840: hz_parties party,
841: hz_relationships rel,
842: hz_org_contacts org_cont,
843: hz_parties rel_party
844: WHERE acct_role.party_id = rel.party_id

Line 843: hz_parties rel_party

839: FROM hz_cust_account_roles acct_role,
840: hz_parties party,
841: hz_relationships rel,
842: hz_org_contacts org_cont,
843: hz_parties rel_party
844: WHERE acct_role.party_id = rel.party_id
845: AND acct_role.role_type = 'CONTACT'
846: and org_cont.party_relationship_id = rel.relationship_id
847: and rel.subject_id = party.party_id

Line 849: and rel.subject_table_name = 'HZ_PARTIES'

845: AND acct_role.role_type = 'CONTACT'
846: and org_cont.party_relationship_id = rel.relationship_id
847: and rel.subject_id = party.party_id
848: and rel.party_id = rel_party.party_id
849: and rel.subject_table_name = 'HZ_PARTIES'
850: and rel.object_table_name = 'HZ_PARTIES'
851: and rel.directional_flag = 'F'
852: and acct_role.cust_account_id = gt.ship_to_customer_id
853: and ( acct_role.cust_acct_site_id = gt.ship_to_address_id

Line 850: and rel.object_table_name = 'HZ_PARTIES'

846: and org_cont.party_relationship_id = rel.relationship_id
847: and rel.subject_id = party.party_id
848: and rel.party_id = rel_party.party_id
849: and rel.subject_table_name = 'HZ_PARTIES'
850: and rel.object_table_name = 'HZ_PARTIES'
851: and rel.directional_flag = 'F'
852: and acct_role.cust_account_id = gt.ship_to_customer_id
853: and ( acct_role.cust_acct_site_id = gt.ship_to_address_id
854: or acct_role.cust_acct_site_id IS NULL )

Line 2627: hz_parties party,

2623: WHERE gt.agreement_id IS NOT NULL
2624: AND NOT EXISTS (
2625: SELECT 'X'
2626: from hz_cust_accounts cust_acct,
2627: hz_parties party,
2628: so_agreements a,
2629: qp_lookups sl
2630: where a.agreement_type_code = sl.lookup_code
2631: and sl.lookup_type = 'QP_AGREEMENT_TYPE'

Line 2969: hz_parties party

2965: UPDATE ar_trx_header_gt gt
2966: SET gt.bill_to_customer_id =
2967: (SELECT cust_acct.cust_account_id
2968: FROM hz_cust_accounts cust_acct,
2969: hz_parties party
2970: WHERE cust_acct.party_id = party.party_id
2971: AND party.party_name = gt.bill_to_customer_name
2972: AND gt.bill_to_customer_id IS NULL
2973: AND gt.bill_to_customer_name IS NOT NULL

Line 3300: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,HZ_PARTIES PARTY,HZ_RELATIONSHIPS REL,

3296: LOOP
3297: BEGIN
3298: SELECT distinct ACCT_ROLE.CUST_ACCOUNT_ROLE_ID -- CONTACT_ID
3299: INTO l_contact_id
3300: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,HZ_PARTIES PARTY,HZ_RELATIONSHIPS REL,
3301: HZ_ORG_CONTACTS ORG_CONT,HZ_PARTIES REL_PARTY
3302: WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
3303: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
3304: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID

Line 3301: HZ_ORG_CONTACTS ORG_CONT,HZ_PARTIES REL_PARTY

3297: BEGIN
3298: SELECT distinct ACCT_ROLE.CUST_ACCOUNT_ROLE_ID -- CONTACT_ID
3299: INTO l_contact_id
3300: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,HZ_PARTIES PARTY,HZ_RELATIONSHIPS REL,
3301: HZ_ORG_CONTACTS ORG_CONT,HZ_PARTIES REL_PARTY
3302: WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
3303: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
3304: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
3305: AND REL.SUBJECT_ID = PARTY.PARTY_ID

Line 3307: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

3303: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
3304: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
3305: AND REL.SUBJECT_ID = PARTY.PARTY_ID
3306: AND REL.PARTY_ID = REL_PARTY.PARTY_ID
3307: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
3308: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
3309: AND REL.DIRECTIONAL_FLAG = 'F'
3310: AND ACCT_ROLE.CUST_ACCOUNT_ID = bill_to_customer_id_rec.bill_to_customer_id
3311: AND ACCT_ROLE.CUST_ACCT_SITE_ID = bill_to_customer_id_rec.bill_to_address_id

Line 3308: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

3304: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
3305: AND REL.SUBJECT_ID = PARTY.PARTY_ID
3306: AND REL.PARTY_ID = REL_PARTY.PARTY_ID
3307: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
3308: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
3309: AND REL.DIRECTIONAL_FLAG = 'F'
3310: AND ACCT_ROLE.CUST_ACCOUNT_ID = bill_to_customer_id_rec.bill_to_customer_id
3311: AND ACCT_ROLE.CUST_ACCT_SITE_ID = bill_to_customer_id_rec.bill_to_address_id
3312: AND ACCT_ROLE.STATUS = 'A' ;

Line 3381: hz_parties party

3377: UPDATE ar_trx_header_gt gt
3378: SET gt.ship_to_customer_id =
3379: (SELECT cust_acct.cust_account_id
3380: FROM hz_cust_accounts cust_acct,
3381: hz_parties party
3382: WHERE cust_acct.party_id = party.party_id
3383: AND party.party_name = gt.ship_to_customer_name
3384: AND cust_acct.status = 'A'
3385: AND gt.ship_to_customer_id IS NULL

Line 3499: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,HZ_PARTIES PARTY,HZ_RELATIONSHIPS REL,

3495: LOOP
3496: BEGIN
3497: SELECT distinct ACCT_ROLE.CUST_ACCOUNT_ROLE_ID -- CONTACT_ID
3498: INTO l_contact_id
3499: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,HZ_PARTIES PARTY,HZ_RELATIONSHIPS REL,
3500: HZ_ORG_CONTACTS ORG_CONT,HZ_PARTIES REL_PARTY
3501: WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
3502: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
3503: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID

Line 3500: HZ_ORG_CONTACTS ORG_CONT,HZ_PARTIES REL_PARTY

3496: BEGIN
3497: SELECT distinct ACCT_ROLE.CUST_ACCOUNT_ROLE_ID -- CONTACT_ID
3498: INTO l_contact_id
3499: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,HZ_PARTIES PARTY,HZ_RELATIONSHIPS REL,
3500: HZ_ORG_CONTACTS ORG_CONT,HZ_PARTIES REL_PARTY
3501: WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
3502: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
3503: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
3504: AND REL.SUBJECT_ID = PARTY.PARTY_ID

Line 3506: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

3502: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
3503: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
3504: AND REL.SUBJECT_ID = PARTY.PARTY_ID
3505: AND REL.PARTY_ID = REL_PARTY.PARTY_ID
3506: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
3507: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
3508: AND REL.DIRECTIONAL_FLAG = 'F'
3509: AND ACCT_ROLE.CUST_ACCOUNT_ID = ship_to_customer_id_rec.ship_to_customer_id
3510: AND ACCT_ROLE.CUST_ACCT_SITE_ID = ship_to_customer_id_rec.ship_to_address_id

Line 3507: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

3503: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
3504: AND REL.SUBJECT_ID = PARTY.PARTY_ID
3505: AND REL.PARTY_ID = REL_PARTY.PARTY_ID
3506: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
3507: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
3508: AND REL.DIRECTIONAL_FLAG = 'F'
3509: AND ACCT_ROLE.CUST_ACCOUNT_ID = ship_to_customer_id_rec.ship_to_customer_id
3510: AND ACCT_ROLE.CUST_ACCT_SITE_ID = ship_to_customer_id_rec.ship_to_address_id
3511: AND ACCT_ROLE.STATUS = 'A' ;

Line 5190: hz_parties party

5186: LOOP
5187: SELECT party.party_id
5188: INTO l_party_id
5189: FROM hz_cust_accounts hca,
5190: hz_parties party
5191: WHERE hca.party_id = party.party_id
5192: AND hca.cust_account_id = ctrxHeaderRec.paying_customer_id ;
5193:
5194: SELECT INSTR_ASSIGNMENT_ID