VIEW: APPS.IEX_LS_TRX_BSC_V

Source

View Text - Preformatted

SELECT PS.PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID, CT.TRX_NUMBER TRX_NUMBER, PS.TERMS_SEQUENCE_NUMBER TERMS_SEQUENCE_NUMBER , CT.PURCHASE_ORDER PURCHASE_ORDER, PS.LAST_UPDATE_DATE LAST_UPDATE_DATE, PS.LAST_UPDATED_BY LAST_UPDATED_BY, PS.CREATION_DATE CREATION_DATE, PS.CREATED_BY CREATED_BY, PS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PS.DUE_DATE DUE_DATE, CT.TRX_DATE TRX_DATE, PS.INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE, PS.AMOUNT_DUE_ORIGINAL AMOUNT_DUE_ORIGINAL, PS.AMOUNT_DUE_REMAINING AMOUNT_DUE_REMAINING, PS.ACCTD_AMOUNT_DUE_REMAINING ACCTD_AMOUNT_DUE_REMAINING, PS.STATUS CUST_TRX_STATUS_CODE, AL_STATUS.MEANING CUST_TRX_STATUS_NAME, PS.CLASS CUST_TRX_CLASS_CODE, AL_CLASS.MEANING CUST_TRX_CLASS_NAME, PS.CUST_TRX_TYPE_ID CUST_TRX_TYPE_ID, CTT.NAME CUST_TRX_TYPE_NAME, PARTY.PARTY_ID PARTY_ID, PS.CUSTOMER_ID CUSTOMER_ID, PS.CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID, PS.CUSTOMER_TRX_ID CUSTOMER_TRX_ID, PS.EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, PS.EXCHANGE_DATE EXCHANGE_DATE, PS.EXCHANGE_RATE EXCHANGE_RATE, PS.ORG_ID ORG_ID, PARTY.PARTY_NAME CUSTOMER_NAME, CUST_ACCT.ACCOUNT_NUMBER ACCOUNT_NUMBER, SU.LOCATION CUST_TRX_LOCATION, CT.BILL_TO_CONTACT_ID BILL_TO_CONTACT_ID, RACO_BILL_PARTY.PERSON_FIRST_NAME BILL_TO_FIRST_NAME, RACO_BILL_PARTY.PERSON_LAST_NAME BILL_TO_LAST_NAME, CT.DOC_SEQUENCE_VALUE DOC_SEQUENCE_VALUE FROM AR_LOOKUPS AL_STATUS, AR_PAYMENT_SCHEDULES PS, RA_CUST_TRX_TYPES CTT, RA_CUSTOMER_TRX CT, HZ_CUST_SITE_USES SU , HZ_CUST_ACCOUNTS CUST_ACCT, HZ_PARTIES PARTY, HZ_CUST_ACCOUNT_ROLES RACO_BILL, HZ_PARTIES RACO_BILL_PARTY, HZ_RELATIONSHIPS RACO_BILL_REL, AR_LOOKUPS AL_CLASS WHERE PS.CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID AND PS.CUSTOMER_SITE_USE_ID = SU.SITE_USE_ID AND PS.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID AND CT.BILL_TO_CONTACT_ID = RACO_BILL.CUST_ACCOUNT_ROLE_ID(+) AND RACO_BILL.PARTY_ID = RACO_BILL_REL.PARTY_ID(+) AND RACO_BILL_REL.DIRECTIONAL_FLAG(+) = 'F' AND RACO_BILL.ROLE_TYPE(+) = 'CONTACT' AND RACO_BILL_REL.SUBJECT_ID = RACO_BILL_PARTY.PARTY_ID(+) AND CT.CUST_TRX_TYPE_ID = CTT.CUST_TRX_TYPE_ID AND CT.ORG_ID=CTT.ORG_ID AND PS.STATUS = AL_STATUS.LOOKUP_CODE AND AL_STATUS.LOOKUP_TYPE = 'INVOICE_TRX_STATUS' AND PS.CLASS = AL_CLASS.LOOKUP_CODE AND AL_CLASS.LOOKUP_TYPE = 'INV/CM'

View Text - HTML Formatted

SELECT PS.PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, CT.TRX_NUMBER TRX_NUMBER
, PS.TERMS_SEQUENCE_NUMBER TERMS_SEQUENCE_NUMBER
, CT.PURCHASE_ORDER PURCHASE_ORDER
, PS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PS.LAST_UPDATED_BY LAST_UPDATED_BY
, PS.CREATION_DATE CREATION_DATE
, PS.CREATED_BY CREATED_BY
, PS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PS.DUE_DATE DUE_DATE
, CT.TRX_DATE TRX_DATE
, PS.INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
, PS.AMOUNT_DUE_ORIGINAL AMOUNT_DUE_ORIGINAL
, PS.AMOUNT_DUE_REMAINING AMOUNT_DUE_REMAINING
, PS.ACCTD_AMOUNT_DUE_REMAINING ACCTD_AMOUNT_DUE_REMAINING
, PS.STATUS CUST_TRX_STATUS_CODE
, AL_STATUS.MEANING CUST_TRX_STATUS_NAME
, PS.CLASS CUST_TRX_CLASS_CODE
, AL_CLASS.MEANING CUST_TRX_CLASS_NAME
, PS.CUST_TRX_TYPE_ID CUST_TRX_TYPE_ID
, CTT.NAME CUST_TRX_TYPE_NAME
, PARTY.PARTY_ID PARTY_ID
, PS.CUSTOMER_ID CUSTOMER_ID
, PS.CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID
, PS.CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, PS.EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, PS.EXCHANGE_DATE EXCHANGE_DATE
, PS.EXCHANGE_RATE EXCHANGE_RATE
, PS.ORG_ID ORG_ID
, PARTY.PARTY_NAME CUSTOMER_NAME
, CUST_ACCT.ACCOUNT_NUMBER ACCOUNT_NUMBER
, SU.LOCATION CUST_TRX_LOCATION
, CT.BILL_TO_CONTACT_ID BILL_TO_CONTACT_ID
, RACO_BILL_PARTY.PERSON_FIRST_NAME BILL_TO_FIRST_NAME
, RACO_BILL_PARTY.PERSON_LAST_NAME BILL_TO_LAST_NAME
, CT.DOC_SEQUENCE_VALUE DOC_SEQUENCE_VALUE
FROM AR_LOOKUPS AL_STATUS
, AR_PAYMENT_SCHEDULES PS
, RA_CUST_TRX_TYPES CTT
, RA_CUSTOMER_TRX CT
, HZ_CUST_SITE_USES SU
, HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_PARTIES PARTY
, HZ_CUST_ACCOUNT_ROLES RACO_BILL
, HZ_PARTIES RACO_BILL_PARTY
, HZ_RELATIONSHIPS RACO_BILL_REL
, AR_LOOKUPS AL_CLASS
WHERE PS.CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID
AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
AND PS.CUSTOMER_SITE_USE_ID = SU.SITE_USE_ID
AND PS.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID
AND CT.BILL_TO_CONTACT_ID = RACO_BILL.CUST_ACCOUNT_ROLE_ID(+)
AND RACO_BILL.PARTY_ID = RACO_BILL_REL.PARTY_ID(+)
AND RACO_BILL_REL.DIRECTIONAL_FLAG(+) = 'F'
AND RACO_BILL.ROLE_TYPE(+) = 'CONTACT'
AND RACO_BILL_REL.SUBJECT_ID = RACO_BILL_PARTY.PARTY_ID(+)
AND CT.CUST_TRX_TYPE_ID = CTT.CUST_TRX_TYPE_ID
AND CT.ORG_ID=CTT.ORG_ID
AND PS.STATUS = AL_STATUS.LOOKUP_CODE
AND AL_STATUS.LOOKUP_TYPE = 'INVOICE_TRX_STATUS'
AND PS.CLASS = AL_CLASS.LOOKUP_CODE
AND AL_CLASS.LOOKUP_TYPE = 'INV/CM'