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: AP_XML_BATCHLEVEL_V

Product:	AP - Payables
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT AISC.CHECKRUN_ID BATCH_ID
, AISC.CHECKRUN_NAME BATCH_NAME
, AISC.ORG_ID
, AISC.CHECK_DATE
, AISC.CURRENCY_CODE
, HOU.NAME ORG_NAME
, HL.ADDRESS_LINE_1
, HL.TOWN_OR_CITY
, HL.COUNTRY
, HL.REGION_1
, HL.POSTAL_CODE
, HL.REGION_2
, ABA.BANK_ACCOUNT_NUM
, ABA.BANK_ACCOUNT_TYPE
, ABB.BANK_NUM
, ABB.BANK_NUMBER
, ABB.BANK_NAME
, ABB.BANK_BRANCH_ID
, ABB.BANK_BRANCH_NAME
, ABB.BANK_BRANCH_TYPE
, ABB.ADDRESS_LINE1 BANK_ADDRESS_LINE1
, ABB.CITY BANK_CITY
, ABB.COUNTRY BANK_COUNTRY
, ABB.ZIP BANK_ZIP
, ABB.STATE BANK_STATE
FROM HR_ORGANIZATION_UNITS HOU
, HR_LOCATIONS HL
, AP_INVOICE_SELECTION_CRITERIA AISC
, AP_BANK_ACCOUNTS ABA
, AP_BANK_BRANCHES ABB
WHERE HL.LOCATION_ID = HOU.LOCATION_ID
AND HOU.ORGANIZATION_ID = AISC.ORG_ID
AND AISC.BANK_ACCOUNT_ID = ABA.BANK_ACCOUNT_ID
AND ABA.BANK_BRANCH_ID = ABB.BANK_BRANCH_ID

Columns

Name
BATCH_ID
BATCH_NAME
ORG_ID
CHECK_DATE
CURRENCY_CODE
ORG_NAME
ADDRESS_LINE_1
TOWN_OR_CITY
COUNTRY
REGION_1
POSTAL_CODE
REGION_2
BANK_ACCOUNT_NUM
BANK_ACCOUNT_TYPE
BANK_NUM
BANK_NUMBER
BANK_NAME
BANK_BRANCH_ID
BANK_BRANCH_NAME
BANK_BRANCH_TYPE
BANK_ADDRESS_LINE1
BANK_CITY
BANK_COUNTRY
BANK_ZIP
BANK_STATE