Product: | IGI - Public Sector Financials International |
---|---|
Description: | View for the standing charges forms based on IGI_RPI_STANDING_CHARGES view |
Implementation/DBA Data: | APPS.IGI_RPI_STANDING_CHARGES_V |
SELECT JURSC.CHARGE_REFERENCE
, JURSC.STATUS
, NVL( JURSC.TERM_ID
, 4) TERM_ID
, JURSC.STANDING_CHARGE_DATE
, RCTT.NAME TRANSACTION_TYPE_NAME
, RT.NAME TERM_ID_NAME
, JURSC.CURRENCY_CODE
, RBS.NAME BATCH_SOURCE_NAME
, RS.NAME SALESPERSON
, RCUB.CUSTOMER_NAME BILL_TO_CUSTOMER
, RCUB.CUSTOMER_NUMBER BILL_TO_NUMBER
, RAB.ADDRESS1 BILL_ADDRESS1
, RAB.ADDRESS2 BILL_ADDRESS2
, RAB.ADDRESS3 BILL_ADDRESS3
, DECODE(JURSC.BILL_TO_CONTACT_ID
, ''
, ''
, RCB.LAST_NAME||'
, '||' '||RCB.FIRST_NAME) BILL_CONTACT
, RCUS.CUSTOMER_NAME SHIP_TO_CUSTOMER
, RCUS.CUSTOMER_NUMBER SHIP_TO_NUMBER
, RAS.ADDRESS1 SHIP_ADDRESS1
, RAS.ADDRESS2 SHIP_ADDRESS2
, RAS.ADDRESS3 SHIP_ADDRESS3
, DECODE(JURSC.SHIP_TO_CONTACT_ID
, ''
, ''
, RCS.LAST_NAME||'
, '||' '||RCS.FIRST_NAME) SHIP_CONTACT
, JURSC.DESCRIPTION
, JURSC.COMMENTS
, JURSC.START_DATE
, JURSC.END_DATE
, JURSC.PERIOD_NAME
, JURSC.ADVANCE_ARREARS_IND
, JURSC.NEXT_DUE_DATE
, JURSC.REMINDER_DAYS
, JURSC.REVIEW_DATE
, JURSC.SUPPRESS_INV_PRINT
, ARM.NAME RECEIPT_METHOD_NAME
, JURSC.SET_OF_BOOKS_ID
, JURSC.CUST_TRX_TYPE_ID
, JURSC.GENERATE_SEQUENCE
, JURSC.STANDING_CHARGE_ID
, JURSC.SALESREP_ID
, JURSC.BATCH_SOURCE_ID
, JURSC.BILL_TO_CUSTOMER_ID
, JURSC.SHIP_TO_CUSTOMER_ID
, JURSC.BILL_TO_ADDRESS_ID
, JURSC.SHIP_TO_ADDRESS_ID
, JURSC.BILL_TO_CONTACT_ID
, JURSC.SHIP_TO_CONTACT_ID
, JURSC.RECEIPT_METHOD_ID
, JURSC.BANK_ACCOUNT_ID
, JURSC.BILL_TO_SITE_USE_ID
, JURSC.SHIP_TO_SITE_USE_ID
, RCUB.CUSTOMER_ID
, JURSC.PREVIOUS_DUE_DATE
, JURSC.LAST_UPDATE_DATE
, JURSC.CREATION_DATE
, JURSC.LAST_UPDATED_BY
, JURSC.CREATED_BY
, JURSC.LAST_UPDATE_LOGIN
, JURSC.ROWID ROW_ID
, JURCP.COMPONENT
, JURSC.DEFAULT_INVOICING_RULE
FROM RA_SALESREPS RS
, RA_CUST_TRX_TYPES RCTT
, RA_HCUSTOMERS RCUS
, RA_ADDRESSES RAS
, RA_HCONTACTS RCS
, RA_HCUSTOMERS RCUB
, RA_ADDRESSES RAB
, RA_HCONTACTS RCB
, AR_RECEIPT_METHODS ARM
, IGI_RPI_STANDING_CHARGES JURSC
, RA_BATCH_SOURCES RBS
, IGI_RPI_COMPONENT_PERIODS JURCP
, RA_TERMS_VL RT
WHERE JURSC.CUST_TRX_TYPE_ID = RCTT.CUST_TRX_TYPE_ID AND JURSC.SALESREP_ID = RS.SALESREP_ID AND JURSC.BATCH_SOURCE_ID = RBS.BATCH_SOURCE_ID AND RBS.BATCH_SOURCE_TYPE = 'FOREIGN'
AND ( ( RT.TERM_ID = JURSC.TERM_ID
AND JURSC.TERM_ID IS NOT NULL ) OR ( RT.TERM_ID = 4
AND JURSC.TERM_ID IS NULL ) ) AND JURSC.BILL_TO_CUSTOMER_ID = RCUB.CUSTOMER_ID AND JURSC.BILL_TO_ADDRESS_ID = RAB.ADDRESS_ID
AND JURSC.PERIOD_NAME = JURCP.PERIOD_NAME AND JURSC.BILL_TO_CONTACT_ID = RCB.CONTACT_ID (+) AND JURSC.SHIP_TO_CUSTOMER_ID = RCUS.CUSTOMER_ID (+) AND JURSC.SHIP_TO_ADDRESS_ID = RAS.ADDRESS_ID (+) AND JURSC.SHIP_TO_CONTACT_ID = RCS.CONTACT_ID (+) AND JURSC.RECEIPT_METHOD_ID = ARM.RECEIPT_METHOD_ID(+)