View: FV_ECS_PAYMENT_V

View Text

SELECT DISTINCT APSI.CHECKRUN_NAME CHECKRUN_NAME
, UPPER(SUBSTR(HRORG.NAME
, 1
, 25)) AGENCY_NAME
, UPPER(SUBSTR(NVL(FVS.ALC_CODE
, ' ')
, 1
, 8)) AGENCY_ALC
, UPPER(SUBSTR( NVL(HRLOC.ADDRESS_LINE_1
, ' ')
, 1
, 25)) AGENCY_ADDRESS_LINE1
, UPPER(SUBSTR( NVL(HRLOC.ADDRESS_LINE_2
, ' ')
, 1
, 25)) AGENCY_ADDRESS_LINE2
, UPPER(SUBSTR(NVL(HRLOC.TOWN_OR_CITY||'
, '||HRLOC.REGION_2||' '|| HRLOC.POSTAL_CODE
, ' ')
, 1
, 25)) AGENCY_CITY_STATE_ZIP
, SUBSTR(NVL(HRLOC.TELEPHONE_NUMBER_1
, ' ')
, 1
, 12) AGENCY_PHONE
, UPPER(SUBSTR(NVL(APBB.BANK_BRANCH_TYPE
, ' ')
, 1
, 3)) AGENCY_BANK_ACCOUNT_TYPE
, APSIC.CHECK_AMOUNT VENDOR_CHECK_AMT
, APSIC.SELECTED_CHECK_ID VENDOR_CHECK_ID
, UPPER(SUBSTR( NVL(APSIC.VENDOR_NAME
, ' ')
, 1
, 35)) VENDOR_NAME
, UPPER(SUBSTR(NVL(APSIC.VENDOR_NUM
, ' ')
, 1
, 16)) VENDOR_NUMBER
, UPPER(SUBSTR(NVL(APSIC.ADDRESS_LINE1
, ' ')
, 1
, 35)) VENDOR_ADDRESS_LINE1
, UPPER(SUBSTR(NVL(APSIC.ADDRESS_LINE2
, ' ')
, 1
, 35)) VENDOR_ADDRESS_LINE2
, UPPER(SUBSTR(NVL(APSIC.ADDRESS_LINE3
, ' ')
, 1
, 25)) VENDOR_ADDRESS_LINE3
, UPPER(SUBSTR(NVL(APSIC.CITY||'
, '|| APSIC.STATE||' '||APSIC.ZIP
, ' ')
, 1
, 25)) VENDOR_ADDRESS_LINE4 FROM HR_ORGANIZATION_UNITS HRORG
, FV_SYSTEM_PARAMETERS_V FVS
, HR_LOCATIONS HRLOC
, AP_SELECTED_INVOICES APSI
, AP_SELECTED_INVOICE_CHECKS APSIC
, AP_INVOICE_SELECTION_CRITERIA APISC
, AP_BANK_ACCOUNTS APBA
, AP_BANK_BRANCHES APBB
WHERE FVS.LE_ORGANIZATION_ID = HRORG.ORGANIZATION_ID AND HRORG.LOCATION_ID = HRLOC.LOCATION_ID AND FVS.SET_OF_BOOKS_ID = APSI.SET_OF_BOOKS_ID AND APSI.PAY_SELECTED_CHECK_ID = APSIC.SELECTED_CHECK_ID AND APSI.OK_TO_PAY_FLAG = 'Y'
AND APSIC.OK_TO_PAY_FLAG = 'Y' AND APSI.CHECKRUN_NAME = APISC.CHECKRUN_NAME AND APISC.BANK_ACCOUNT_ID = APBA.BANK_ACCOUNT_ID AND APBA.BANK_BRANCH_ID = APBB.BANK_BRANCH_ID

Columns