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.

[Home] [Help]

View: ARBPA_CUSTOMER_TRX_HEADER

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.ARBPA_CUSTOMER_TRX_HEADER

View Text

SELECT ORIGINAL_COPY
, CUST_ACCOUNT_ID
, PARTY_ID
, PARTY_SITE_ID
, CUST_ACCT_SITE_ID
, ACCOUNT_NUMBER
, ACCOUNT_NAME
, CUSTOMER_PARTY_NAME
, CUSTOMER_TAX_REFERENCE
, CUSTOMER_TAX_PAYER_ID
, CUSTOMER_TAX_REF_NUMBER
, REP_REG_NUMBER
, RECEIPT_METHOD_NAME
, PAYMENT_METHOD_NAME
, CUSTOMER_ADDRESS
, CUSTOMER_CITY
, CUSTOMER_STATE
, CUSTOMER_COUNTY
, CUSTOMER_POSTAL_CODE
, CUSTOMER_ADDRESS|| ' '|| CUSTOMER_CITY|| ' ' || CUSTOMER_STATE|| ' '|| CUSTOMER_COUNTY|| ' ' || CUSTOMER_POSTAL_CODE CUSTOMER_COMPLETE_ADDRESS
, NVL(TRIM(BOTH '
, '
FROM CUSTOMER_NAME_ATTR||'
, '||CUSTOMER_ADDRESS_ATTR)
, 'THE SAME') CUSTOMER_ATTR_COMPLETE_ADDRESS
, CUSTOMER_NAME_ATTR
, CUSTOMER_ADDRESS_ATTR
, RCT_GLOBAL_ATTRIBUTE3
, RCT_GLOBAL_ATTRIBUTE4
, RCT_GLOBAL_ATTRIBUTE5
, RCT_GLOBAL_ATTRIBUTE6
, RCT_GLOBAL_ATTRIBUTE7
, RCT_GLOBAL_ATTRIBUTE8
, RCT_GLOBAL_ATTRIBUTE9
, RCT_GLOBAL_ATTRIBUTE10
, RCT_GLOBAL_ATTRIBUTE11
, RCT_GLOBAL_ATTRIBUTE12
, RCT_GLOBAL_ATTRIBUTE13
, RCT_GLOBAL_ATTRIBUTE14
, RCT_GLOBAL_ATTRIBUTE15
, TRANSACTION_ID
, TRANSACTION_NUMBER
, TRANSACTION_DATE
, TRANSACTION_TERM_DUE_DATE
, TRANSACTION_CURRENCY_CODE
, DOCUMENT_SEQUENCE_NUMBER
, WAYBILL_NUMBER
, TRANSACTION_TYPE
, SHIPPING_BILL
, SHIPPING_DATE
, VENDOR_PARTY_NAME
, VENDOR_ADDRESS
, VENDOR_CITY
, VENDOR_STATE
, VENDOR_COUNTY
, VENDOR_POSTAL_CODE
, VENDOR_ADDRESS|| ' '|| VENDOR_CITY|| ' ' || VENDOR_STATE|| ' '|| VENDOR_COUNTY|| ' ' || VENDOR_POSTAL_CODE VENDOR_COMPLETE_ADDRESS
, VENDOR_TAX_REFERENCE
, SALES_PERSON_NAME
, TERM_NAME
, TERM_DESC
, VENDOR_TAX_REG_NUMBER
, CUSTOMER_TAX_REG_NUMBER
, CUSTOMER_TAX_AUTHORITY
, USER_NAME
, LINE_TOTAL_AMOUNT
, TAX_TOTAL_AMOUNT
, ((TAX_TOTAL_AMOUNT * 100) / LINE_TOTAL_AMOUNT) TAX_RATE
, VAT_TAX_TOTAL_AMOUNT
, ((VAT_TAX_TOTAL_AMOUNT * 100) / LINE_TOTAL_AMOUNT) VAT_TAX_RATE
, EXCISE_TAX_TOTAL_AMOUNT
, ((EXCISE_TAX_TOTAL_AMOUNT * 100) / LINE_TOTAL_AMOUNT) EXCISE_TAX_RATE
, EXEMPT_TAX_TOTAL_AMOUNT
, ((EXEMPT_TAX_TOTAL_AMOUNT * 100) / LINE_TOTAL_AMOUNT) EXEMPT_TAX_RATE
, (LINE_TOTAL_AMOUNT + TAX_TOTAL_AMOUNT) TRX_TOTAL_AMOUNT
, INITCAP (TO_CHAR (TO_DATE ((NVL(LINE_TOTAL_AMOUNT
, 1) + NVL(TAX_TOTAL_AMOUNT
, 1))
, 'J' )
, 'JSP' ) ) TRX_TOTAL_IN_WORDS
, TRIM(BOTH '-'
FROM PHONE_NUMBER) PHONE_NUMBER
, VENDOR_CONTACT_NAME
, TRIM (BOTH '
, '
FROM CUSTOMER_CONTACT_NAME) CUSTOMER_CONTACT_NAME
, NULL NULL_VALUE
, CHIEF_ACCOUNTANT_NAME
, GENERAL_DIRECTOR_NAME
, VENDOR_TAX_KPP
, VENDOR_TAX_PAYER_ID
, LEGAL_ENTITY_ADDRESS
FROM (SELECT DECODE (RCT.PRINTING_PENDING
, 'Y'
, 'ORIGINAL'
, 'COPY') ORIGINAL_COPY
, HCA.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, HCA.PARTY_ID PARTY_ID
, HCAS.PARTY_SITE_ID PARTY_SITE_ID
, HCAS.CUST_ACCT_SITE_ID CUST_ACCT_SITE_ID
, HCA.ACCOUNT_NUMBER ACCOUNT_NUMBER
, HCA.ACCOUNT_NAME ACCOUNT_NAME
, CUST_HPAR.PARTY_NAME CUSTOMER_PARTY_NAME
, CUST_HPAR.TAX_REFERENCE CUSTOMER_TAX_REFERENCE
, HOP.JGZZ_FISCAL_CODE CUSTOMER_TAX_PAYER_ID
, HOP.TAX_REFERENCE CUSTOMER_TAX_REF_NUMBER
, CUST_ZPTP.REP_REGISTRATION_NUMBER REP_REG_NUMBER
, ARM.NAME RECEIPT_METHOD_NAME
, IFPC.PAYMENT_CHANNEL_NAME PAYMENT_METHOD_NAME
, TRIM ( CUST_HPAR.ADDRESS1|| ' ' || CUST_HPAR.ADDRESS2|| ' ' || CUST_HPAR.ADDRESS3|| ' ' || CUST_HPAR.ADDRESS4) CUSTOMER_ADDRESS
, CUST_HPAR.CITY CUSTOMER_CITY
, CUST_HPAR.STATE CUSTOMER_STATE
, CUST_HPAR.COUNTY CUSTOMER_COUNTY
, CUST_HPAR.POSTAL_CODE CUSTOMER_POSTAL_CODE
, RCT.GLOBAL_ATTRIBUTE1 CUSTOMER_NAME_ATTR
, RCT.GLOBAL_ATTRIBUTE2 CUSTOMER_ADDRESS_ATTR
, RCT.GLOBAL_ATTRIBUTE3 RCT_GLOBAL_ATTRIBUTE3
, RCT.GLOBAL_ATTRIBUTE4 RCT_GLOBAL_ATTRIBUTE4
, RCT.GLOBAL_ATTRIBUTE5 RCT_GLOBAL_ATTRIBUTE5
, RCT.GLOBAL_ATTRIBUTE6 RCT_GLOBAL_ATTRIBUTE6
, RCT.GLOBAL_ATTRIBUTE7 RCT_GLOBAL_ATTRIBUTE7
, RCT.GLOBAL_ATTRIBUTE8 RCT_GLOBAL_ATTRIBUTE8
, RCT.GLOBAL_ATTRIBUTE9 RCT_GLOBAL_ATTRIBUTE9
, RCT.GLOBAL_ATTRIBUTE10 RCT_GLOBAL_ATTRIBUTE10
, RCT.GLOBAL_ATTRIBUTE11 RCT_GLOBAL_ATTRIBUTE11
, RCT.GLOBAL_ATTRIBUTE12 RCT_GLOBAL_ATTRIBUTE12
, RCT.GLOBAL_ATTRIBUTE13 RCT_GLOBAL_ATTRIBUTE13
, RCT.GLOBAL_ATTRIBUTE14 RCT_GLOBAL_ATTRIBUTE14
, RCT.GLOBAL_ATTRIBUTE15 RCT_GLOBAL_ATTRIBUTE15
, RCT.CUSTOMER_TRX_ID TRANSACTION_ID
, RCT.TRX_NUMBER TRANSACTION_NUMBER
, RCT.TRX_DATE TRANSACTION_DATE
, RCT.TERM_DUE_DATE TRANSACTION_TERM_DUE_DATE
, RCT.INVOICE_CURRENCY_CODE TRANSACTION_CURRENCY_CODE
, RCT.DOC_SEQUENCE_VALUE DOCUMENT_SEQUENCE_NUMBER
, RCT.WAYBILL_NUMBER WAYBILL_NUMBER
, RCTT.NAME TRANSACTION_TYPE
, RCT.ATTRIBUTE15 SHIPPING_BILL
, RCT.SHIP_DATE_ACTUAL SHIPPING_DATE
, VNDR_HPAR.PARTY_NAME VENDOR_PARTY_NAME
, VNDR_HPAR.ADDRESS1 VENDOR_ADDRESS
, VNDR_HPAR.CITY VENDOR_CITY
, VNDR_HPAR.STATE VENDOR_STATE
, VNDR_HPAR.COUNTY VENDOR_COUNTY
, VNDR_HPAR.POSTAL_CODE VENDOR_POSTAL_CODE
, VNDR_HPAR.TAX_REFERENCE VENDOR_TAX_REFERENCE
, RS.NAME SALES_PERSON_NAME
, RT.NAME TERM_NAME
, RT.DESCRIPTION TERM_DESC
, VNDR_ZR.REGISTRATION_NUMBER VENDOR_TAX_REG_NUMBER
, CUST_ZR.REGISTRATION_NUMBER CUSTOMER_TAX_REG_NUMBER
, TAX_AUTH_HPAR.PARTY_NAME CUSTOMER_TAX_AUTHORITY
, FND_GLOBAL.USER_NAME USER_NAME
, NVL((SELECT SUM (RCTL.EXTENDED_AMOUNT)
FROM RA_CUSTOMER_TRX_LINES_ALL RCTL
WHERE RCTL.CUSTOMER_TRX_ID = RCT.CUSTOMER_TRX_ID
AND RCTL.LINE_TYPE = 'LINE')
, 0) LINE_TOTAL_AMOUNT
, NVL((SELECT SUM (RCTL.EXTENDED_AMOUNT)
FROM RA_CUSTOMER_TRX_LINES_ALL RCTL
WHERE RCTL.CUSTOMER_TRX_ID = RCT.CUSTOMER_TRX_ID
AND RCTL.LINE_TYPE = 'TAX')
, 0) TAX_TOTAL_AMOUNT
, -- NVL ((SELECT SUM (RCTL.TAX_RATE) --
FROM RA_CUSTOMER_TRX_LINES_ALL RCTL --
WHERE RCTL.CUSTOMER_TRX_ID = RCT.CUSTOMER_TRX_ID --
AND RCTL.LINE_TYPE = 'TAX')
, 0) TAX_RATE
, NVL((SELECT SUM (RCTL.EXTENDED_AMOUNT)
FROM RA_CUSTOMER_TRX_LINES_ALL RCTL
, ZX_LINES ZL
WHERE RCTL.CUSTOMER_TRX_ID = RCT.CUSTOMER_TRX_ID
AND RCTL.LINE_TYPE = 'TAX'
AND RCTL.TAX_LINE_ID = ZL.TAX_LINE_ID
AND ZL.TAX_TYPE_CODE='VAT')
, 0) VAT_TAX_TOTAL_AMOUNT
, -- NVL ((SELECT SUM (RCTL.TAX_RATE) --
FROM RA_CUSTOMER_TRX_LINES_ALL RCTL --
, ZX_LINES ZL --
WHERE RCTL.CUSTOMER_TRX_ID = RCT.CUSTOMER_TRX_ID --
AND RCTL.LINE_TYPE = 'TAX' --
AND RCTL.TAX_LINE_ID = ZL.TAX_LINE_ID --
AND ZL.TAX_TYPE_CODE='VAT')
, 0) VAT_TAX_RATE
, NVL((SELECT SUM (RCTL.EXTENDED_AMOUNT)
FROM RA_CUSTOMER_TRX_LINES_ALL RCTL
, ZX_LINES ZL
WHERE RCTL.CUSTOMER_TRX_ID = RCT.CUSTOMER_TRX_ID
AND RCTL.LINE_TYPE = 'TAX'
AND RCTL.TAX_LINE_ID = ZL.TAX_LINE_ID
AND ZL.TAX_TYPE_CODE='EXCISE')
, 0) EXCISE_TAX_TOTAL_AMOUNT
, -- NVL ((SELECT SUM (RCTL.TAX_RATE) --
FROM RA_CUSTOMER_TRX_LINES_ALL RCTL --
, ZX_LINES ZL --
WHERE RCTL.CUSTOMER_TRX_ID = RCT.CUSTOMER_TRX_ID --
AND RCTL.LINE_TYPE = 'TAX' --
AND RCTL.TAX_LINE_ID = ZL.TAX_LINE_ID --
AND ZL.TAX_TYPE_CODE='EXCISE')
, 0) EXCISE_TAX_RATE
, NVL((SELECT SUM (RCTL.EXTENDED_AMOUNT)
FROM RA_CUSTOMER_TRX_LINES_ALL RCTL
, ZX_LINES ZL
WHERE RCTL.CUSTOMER_TRX_ID = RCT.CUSTOMER_TRX_ID
AND RCTL.LINE_TYPE = 'TAX'
AND RCTL.TAX_LINE_ID = ZL.TAX_LINE_ID
AND ZL.TAX_TYPE_CODE='EXEMPT TAX')
, 0) EXEMPT_TAX_TOTAL_AMOUNT
, -- NVL ((SELECT SUM (RCTL.TAX_RATE) --
FROM RA_CUSTOMER_TRX_LINES_ALL RCTL --
, ZX_LINES ZL --
WHERE RCTL.CUSTOMER_TRX_ID = RCT.CUSTOMER_TRX_ID --
AND RCTL.LINE_TYPE = 'TAX' --
AND RCTL.TAX_LINE_ID = ZL.TAX_LINE_ID --
AND ZL.TAX_TYPE_CODE='EXEMPT TAX')
, 0) EXEMPT_TAX_RATE
, CUST_HPAR.PRIMARY_PHONE_COUNTRY_CODE|| '-' || CUST_HPAR.PRIMARY_PHONE_AREA_CODE|| '-' || CUST_HPAR.PRIMARY_PHONE_NUMBER PHONE_NUMBER
, NVL(VNDR_HPAR.PERSON_TITLE
, VNDR_HPAR.PERSON_PRE_NAME_ADJUNCT)|| ' ' || VNDR_HPAR.PERSON_FIRST_NAME|| ' ' || VNDR_HPAR.PERSON_MIDDLE_NAME|| ' ' || VNDR_HPAR.PERSON_LAST_NAME VENDOR_CONTACT_NAME
, SUBSTRB(CONT_HPAR.PERSON_LAST_NAME
, 1
, 50)|| '
, '|| ' ' || SUBSTRB (CONT_HPAR.PERSON_FIRST_NAME
, 1
, 50) CUSTOMER_CONTACT_NAME
, (SELECT PER_HPAR.PARTY_NAME
FROM HZ_PARTIES PER_HPAR
, HZ_RELATIONSHIPS VNDR_HR
WHERE VNDR_HPAR.PARTY_ID = VNDR_HR.OBJECT_ID
AND VNDR_HR.RELATIONSHIP_CODE = 'CONTACT_OF'
AND VNDR_HR.RELATIONSHIP_TYPE = 'CONTACT'
AND VNDR_HR.DIRECTIONAL_FLAG = 'F'
AND VNDR_HR.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND VNDR_HR.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND VNDR_HR.SUBJECT_TYPE = 'PERSON'
AND TRUNC (NVL (VNDR_HR.END_DATE
, SYSDATE)) > TRUNC (SYSDATE)
AND VNDR_HR.SUBJECT_ID = PER_HPAR.PARTY_ID
AND XLE_CONTACT_GRP.CONCAT_CONTACT_ROLES(VNDR_HR.SUBJECT_ID
, VNDR_HR.OBJECT_ID) = 'CHIEF ACCOUNTANT') CHIEF_ACCOUNTANT_NAME
, (SELECT PER_HPAR.PARTY_NAME
FROM HZ_PARTIES PER_HPAR
, HZ_RELATIONSHIPS VNDR_HR
WHERE VNDR_HPAR.PARTY_ID = VNDR_HR.OBJECT_ID
AND VNDR_HR.RELATIONSHIP_CODE = 'CONTACT_OF'
AND VNDR_HR.RELATIONSHIP_TYPE = 'CONTACT'
AND VNDR_HR.DIRECTIONAL_FLAG = 'F'
AND VNDR_HR.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND VNDR_HR.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND VNDR_HR.SUBJECT_TYPE = 'PERSON'
AND TRUNC (NVL (VNDR_HR.END_DATE
, SYSDATE)) > TRUNC (SYSDATE)
AND VNDR_HR.SUBJECT_ID = PER_HPAR.PARTY_ID
AND XLE_CONTACT_GRP.CONCAT_CONTACT_ROLES(VNDR_HR.SUBJECT_ID
, VNDR_HR.OBJECT_ID) ='GENERAL DIRECTOR') GENERAL_DIRECTOR_NAME
, (SELECT REGISTRATIONEO.REGISTRATION_NUMBER
FROM XLE_REGISTRATIONS REGISTRATIONEO
, XLE_JURISDICTIONS_VL JURISDICTIONS
WHERE JURISDICTIONS.JURISDICTION_ID =REGISTRATIONEO.JURISDICTION_ID
AND REGISTRATIONEO.SOURCE_TABLE = 'XLE_ETB_PROFILES'
AND REGISTRATIONEO.SOURCE_ID = XEV.ESTABLISHMENT_ID
AND NVL (JURISDICTIONS.REGISTRATION_CODE_ETB
, 'RN') ='CRR')VENDOR_TAX_KPP
, (SELECT REGISTRATIONEO.REGISTRATION_NUMBER
FROM XLE_REGISTRATIONS REGISTRATIONEO
, XLE_JURISDICTIONS_VL JURISDICTIONS
WHERE JURISDICTIONS.JURISDICTION_ID =REGISTRATIONEO.JURISDICTION_ID
AND REGISTRATIONEO.SOURCE_TABLE = 'XLE_ENTITY_PROFILES'
AND REGISTRATIONEO.SOURCE_ID = XEP.LEGAL_ENTITY_ID
AND NVL (JURISDICTIONS.REGISTRATION_CODE_LE
, 'RN') ='INT')VENDOR_TAX_PAYER_ID
, (SELECT LTRIM ( LOC.ADDRESS_LINE_1|| ' ' || LOC.ADDRESS_LINE_2|| ' ' || LOC.ADDRESS_LINE_3|| ' ' || LOC.TOWN_OR_CITY|| ' ' || LOC.REGION_2|| ' ' || LOC.POSTAL_CODE) ADDRESS
FROM XLE_REGISTRATIONS XLR
, HR_LOCATIONS LOC
WHERE XLR.SOURCE_TABLE = 'XLE_ENTITY_PROFILES'
AND XLR.SOURCE_ID = XEP.LEGAL_ENTITY_ID
AND XLR.LOCATION_ID = LOC.LOCATION_ID(+)) LEGAL_ENTITY_ADDRESS
FROM RA_CUSTOMER_TRX_ALL RCT
, RA_CUST_TRX_TYPES_ALL RCTT
, RA_TERMS RT
, RA_SALESREPS_ALL RS
, HZ_CUST_ACCOUNTS HCA
, HZ_PARTIES CUST_HPAR
, HZ_CUST_SITE_USES_ALL HCSU
, HZ_CUST_ACCT_SITES_ALL HCAS
, HZ_PARTY_SITES HPS
, XLE_ENTITY_PROFILES XEP
, HZ_PARTIES VNDR_HPAR
, XLE_ETB_PROFILES XEV
, HZ_PARTIES ESTAB_HPAR
, ZX_PARTY_TAX_PROFILE VNDR_ZPTP
, ZX_REGISTRATIONS VNDR_ZR
, ZX_PARTY_TAX_PROFILE CUST_ZPTP
, ZX_REGISTRATIONS CUST_ZR
, HZ_LOCATIONS HL
, FND_TERRITORIES_TL FTT
, ZX_PARTY_TAX_PROFILE TAX_AUTH_ZPTP
, XLE_LEGALAUTH_V XLV
, HZ_PARTIES TAX_AUTH_HPAR
, HZ_CUST_ACCOUNT_ROLES CONT_HCAR
, HZ_RELATIONSHIPS CONT_HR
, HZ_PARTIES CONT_HPAR
, AR_RECEIPT_METHODS ARM
, IBY_FNDCPT_PMT_CHNNLS_VL IFPC
, HZ_ORGANIZATION_PROFILES HOP
WHERE RCT.CUST_TRX_TYPE_ID = RCTT.CUST_TRX_TYPE_ID
AND RCT.TERM_ID = RT.TERM_ID(+)
AND RCT.PRIMARY_SALESREP_ID = RS.SALESREP_ID(+)
AND RCT.ORG_ID = RS.ORG_ID(+)
AND RCT.BILL_TO_CUSTOMER_ID = HCA.CUST_ACCOUNT_ID
AND HCA.PARTY_ID = CUST_HPAR.PARTY_ID
AND RCT.BILL_TO_SITE_USE_ID = HCSU.SITE_USE_ID
AND HCA.CUST_ACCOUNT_ID = HCAS.CUST_ACCOUNT_ID
AND HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID
AND HCAS.PARTY_SITE_ID = HPS.PARTY_SITE_ID
AND RCT.LEGAL_ENTITY_ID = XEP.LEGAL_ENTITY_ID
AND XEP.PARTY_ID = VNDR_HPAR.PARTY_ID
AND XEV.LEGAL_ENTITY_ID = XEP.LEGAL_ENTITY_ID
AND XEV.PARTY_ID = ESTAB_HPAR.PARTY_ID
AND XEV.MAIN_ESTABLISHMENT_FLAG = 'Y'
AND ESTAB_HPAR.PARTY_ID = VNDR_ZPTP.PARTY_ID
AND VNDR_ZPTP.PARTY_TAX_PROFILE_ID = VNDR_ZR.PARTY_TAX_PROFILE_ID(+)
AND VNDR_ZR.DEFAULT_REGISTRATION_FLAG(+) = 'Y'
AND CUST_HPAR.PARTY_ID = CUST_ZPTP.PARTY_ID
AND CUST_ZPTP.PARTY_TAX_PROFILE_ID = CUST_ZR.PARTY_TAX_PROFILE_ID(+)
AND CUST_ZR.DEFAULT_REGISTRATION_FLAG(+) = 'Y'
AND HPS.LOCATION_ID = HL.LOCATION_ID
AND HL.COUNTRY = FTT.TERRITORY_CODE(+)
AND NVL (FTT.LANGUAGE
, USERENV ('LANG')) = USERENV ('LANG')
AND VNDR_ZR.TAX_AUTHORITY_ID = TAX_AUTH_ZPTP.PARTY_TAX_PROFILE_ID(+)
AND TAX_AUTH_ZPTP.PARTY_TYPE_CODE(+) = 'TAX_AUTHORITY'
AND TAX_AUTH_ZPTP.PARTY_ID = XLV.LEGALAUTH_ID(+)
AND XLV.PARTY_ID = TAX_AUTH_HPAR.PARTY_ID(+)
AND RCT.BILL_TO_CONTACT_ID = CONT_HCAR.CUST_ACCOUNT_ROLE_ID(+)
AND CONT_HCAR.ROLE_TYPE(+) = 'CONTACT'
AND CONT_HCAR.PARTY_ID = CONT_HR.PARTY_ID(+)
AND CONT_HR.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
AND CONT_HR.OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
AND CONT_HR.DIRECTIONAL_FLAG(+) = 'F'
AND CONT_HR.SUBJECT_ID = CONT_HPAR.PARTY_ID(+)
AND RCT.RECEIPT_METHOD_ID = ARM.RECEIPT_METHOD_ID(+)
AND ARM.PAYMENT_CHANNEL_CODE = IFPC.PAYMENT_CHANNEL_CODE(+)
AND CUST_HPAR.PARTY_ID = HOP.PARTY_ID(+)
AND HOP.EFFECTIVE_END_DATE IS NULL)