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

Line 900: hz_parties CHParty,

896: FROM ar_receipt_method_accounts rma2,
897: ce_bank_accounts cba2,
898: ce_bank_acct_uses ba2,
899: ce_bank_branches_v bb2,
900: hz_parties CHParty,
901: hz_parties RelParty,
902: hz_relationships BCRel,
903: hz_contact_points Eft
904: WHERE rma2.receipt_method_id = l_batch_rec.receipt_method_id

Line 901: hz_parties RelParty,

897: ce_bank_accounts cba2,
898: ce_bank_acct_uses ba2,
899: ce_bank_branches_v bb2,
900: hz_parties CHParty,
901: hz_parties RelParty,
902: hz_relationships BCRel,
903: hz_contact_points Eft
904: WHERE rma2.receipt_method_id = l_batch_rec.receipt_method_id
905: AND rma2.remit_bank_acct_use_id = ba2.bank_acct_use_id

Line 911: AND BCRel.subject_table_name = 'HZ_PARTIES'

907: AND cba2.currency_code = l_batch_rec.currency_code
908: AND cba2.bank_branch_id = bb2.branch_party_id
909: AND BCRel.subject_id = bb2.branch_party_id
910: AND BCRel.subject_type = 'ORGANIZATION'
911: AND BCRel.subject_table_name = 'HZ_PARTIES'
912: AND BCRel.object_id = CHParty.party_id
913: AND BCRel.object_type = 'ORGANIZATION'
914: AND BCRel.object_table_name = 'HZ_PARTIES'
915: AND BCRel.relationship_type = 'CLEARINGHOUSE_BANK'

Line 914: AND BCRel.object_table_name = 'HZ_PARTIES'

910: AND BCRel.subject_type = 'ORGANIZATION'
911: AND BCRel.subject_table_name = 'HZ_PARTIES'
912: AND BCRel.object_id = CHParty.party_id
913: AND BCRel.object_type = 'ORGANIZATION'
914: AND BCRel.object_table_name = 'HZ_PARTIES'
915: AND BCRel.relationship_type = 'CLEARINGHOUSE_BANK'
916: AND BCRel.relationship_code = 'USES_CLEARINGHOUSE'
917: AND BCRel.status = 'A'
918: AND RelParty.party_id = BCRel.party_id

Line 919: AND Eft.owner_table_name(+) = 'HZ_PARTIES'

915: AND BCRel.relationship_type = 'CLEARINGHOUSE_BANK'
916: AND BCRel.relationship_code = 'USES_CLEARINGHOUSE'
917: AND BCRel.status = 'A'
918: AND RelParty.party_id = BCRel.party_id
919: AND Eft.owner_table_name(+) = 'HZ_PARTIES'
920: AND Eft.owner_table_id(+) = CHParty.party_id
921: AND Eft.contact_point_type(+) = 'EFT'
922: AND Eft.status(+) = 'A'
923: AND CHParty.party_id = bb.branch_party_id));