[Home] [Help]
View: FIIBV_AP_IVTY_INV_LCV
Product: | FII - Financial Intelligence (Obsolete) |
Description: | None. Internal Table. |
Implementation/DBA Data: |
Not implemented in this database
|
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" |