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

Product:	FII - Financial Intelligence
Description:	None. Internal Table.
Implementation/DBA Data:	APPS.FIIBV_AP_IVTY_INV_LCV

View Text

SELECT TO_CHAR(INVOICE_ID)||'-'||TO_CHAR(ORG_ID)|| '-'||SUBSTRB(EDW_INSTANCE.GET_CODE
, 1
, 40) INV_PK
, INVOICE_TYPE_LOOKUP_CODE INV_TYPE_FK
, TO_CHAR(INVOICE_ID) INV_ID
, INVOICE_NUM NAME
, INVOICE_NUM INV_NAME
, SUBSTRB(EDW_INSTANCE.GET_CODE
, 1
, 40) INSTANCE
, SOURCE INV_SOURCE
, CANCELLED_DATE CANCELLED_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, NULL DELETION_DATE
, NULL INV_DP
, '_DF:SQLAP:AP_INVOICES:AI'
, '_DF:SQLAP:AP_GOV_DETAIL_INVOICES:AI'
, '_DF:JG:JG_AP_INVOICES:AI'
FROM AP_INVOICES_ALL AI

Columns

Name
INV_PK
INV_TYPE_FK
INV_ID
NAME
INV_NAME
INSTANCE
INV_SOURCE
CANCELLED_DATE
LAST_UPDATE_DATE
CREATION_DATE
DELETION_DATE
INV_DP
"_DF:INV:_EDW"
"_DF:GOV:_EDW"
"_DF:JGI:_EDW"