DBA Data[Home] [Help] [Dependency Information]

TABLE: FII.FII_AP_INV_LINES_FSTG

Object Details
Object Name: FII_AP_INV_LINES_FSTG
Object Type: TABLE
Owner: FII
FND Design Data: TableFII.FII_AP_INV_LINES_FSTG
Subobject Name:
Status: VALID


This is the interface table for AP invoice lines fact. Data from multiple transactional systems is staged here for verification and cleansing, before loading it into the fact table.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FII_AP_INV_LINES_FSTG_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnINV_LINE_PK
FII_AP_INV_LINES_FSTG_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnCOLLECTION_STATUS
Columns
Name Datatype Length Mandatory Comments
USER_MEASURE5 NUMBER

User defined measure
USER_MEASURE4 NUMBER

User defined measure
USER_MEASURE3 NUMBER

User defined measure
USER_MEASURE2 NUMBER

User defined measure
USER_MEASURE1 NUMBER

User defined measure
USER_FK9_KEY NUMBER

System generated foreign key for the user defined dimension
USER_FK8_KEY NUMBER

System generated foreign key for the user defined dimension
USER_FK7_KEY NUMBER

System generated foreign key for the user defined dimension
USER_FK6_KEY NUMBER

System generated foreign key for the user defined dimension
USER_FK5_KEY NUMBER

System generated foreign key for the user defined dimension
USER_FK4_KEY NUMBER

System generated foreign key for the user defined dimension
USER_FK3_KEY NUMBER

System generated foreign key for the user defined dimension
USER_FK2_KEY NUMBER

System generated foreign key for the user defined dimension
USER_FK1_KEY NUMBER

System generated foreign key for the user defined dimension
USER_FK10_KEY NUMBER

System generated foreign key for the user defined dimension
UOM_T_FK_KEY NUMBER

A foreign key generated by the warehouse that points to the unit of measure dimension at the lowest level.
UOM_G_FK_KEY NUMBER

A foreign key generated by the warehouse that points to the unit of measure dimension at the lowest level.
UNMATCH_LINE_COUNT NUMBER

Set to 1 if this is a non PO matched invoice. 0 otherwise
UNMATCH_LINE_AMT_T NUMBER

Invoice line amount in transactional currency for invoice line not matched to PO.
UNMATCH_LINE_AMT_G NUMBER

Invoice line amount in global currency for invoice line not matched to PO.
UNMATCH_LINE_AMT_B NUMBER

Invoice line amount in functional currency for invoice line not matched to PO.
TOTAL_VAR_AMT_T NUMBER

Total variance amount in transactional currency between PO and the corresponding matched invoice.
TOTAL_VAR_AMT_G NUMBER

Total variance amount in global currency between the PO and the corresponding matched invoice.
TOTAL_VAR_AMT_B NUMBER

Total variance amount in functional currency between the PO and the corresponding matched invoice.
TASK_ID NUMBER

Identifier for project task used to build the default Accounting Flexifield.
SUPPLIER_SITE_ID NUMBER

Identifier for supplier site
SUPPLIER_FK_KEY NUMBER

A foreign key generated by the warehouse that points to the supplier dimension at the lowest level.
SOB_FK_KEY NUMBER

A foreign key generated by the warehouse that points to the set of books dimension at the lowest level.
SIC_CODE_FK_KEY NUMBER

A foreign key generated by the warehouse that points to the standard industry code, SIC, dimension at the lowest level.
DUNS_FK_KEY NUMBER

A foreign key generated by the warehouse that points to the data universal numbering system, DUNS, dimension at the lowest level.
UNSPSC_FK_KEY NUMBER

A foreign key generated by the warehouse that points to the universal standard product and services classification code, UNSPSC, dimension at the lowest level.
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
QUANTITY_INVOICED_T NUMBER

Quantity in transaction unit of measure billed for PO matched invoice line
QUANTITY_INVOICED_G NUMBER

Quantity invoiced in warehouse unit of measure
QTY_VAR_AMT_T NUMBER

The amount difference in transactional currency due to the quantity difference between the PO quantity and the invoiced quantity for the matched invoice line
QTY_VAR_AMT_G NUMBER

The amount difference in global currency due to the quantity difference between the PO quantity and the invoiced quantity for the matched invoice line.
QTY_VAR_AMT_B NUMBER

The amount difference in functional currency due to the quantity difference between the PO quantity and the invoice quantity for the matched invoice line.
PROJECT_ID NUMBER

Identifier used for a project used to build Accounting Flexfield for project-related invoice line.
PO_UNIT_PRICE_T NUMBER

PO unit price in transactional currency for the item invoiced
PO_UNIT_PRICE_G NUMBER

PO unit price in global currency for the item invoiced
PO_UNIT_PRICE_B NUMBER

PO unit price in functional currency for the item invoiced. This unit price is converted to functional currency using the exchange rate from PO_HEADERS table.
PO_DISTRIBUTION_ID NUMBER

PO distribution identifier which is matched to this invoice line
PO_AMT_T NUMBER

PO amount in transactional currency matched to this invoice line. For PO matched invoice line only.
PO_AMT_G NUMBER

PO amount in global currency matched to this invoice line. For PO matched invoice line only.
PO_AMT_B NUMBER

PO amount in functional currency matched to this invoice line. For PO matched invoice line only.
POSTED_AMT_T NUMBER

Amount posted to the general ledger in transactional currency.
POSTED_AMT_G NUMBER

Amount posted to the general ledger in global currency
POSTED_AMT_B NUMBER

Amount posted to the general ledger in functional currency
PAYMENT_TERM_FK_KEY NUMBER

A foreign key generated by the warehouse that points to the payment term dimension at the lowest level.
ORG_FK_KEY NUMBER

A foreign key generated by the warehouse that points to the organization dimension at the lowest level.
MATCH_LINE_COUNT NUMBER

Set to 1 if this invoice line is PO matched. 0 otherwise
MATCH_LINE_AMT_T NUMBER

Invoice line amount in transactional currency for PO matched invoice line
MATCH_LINE_AMT_G NUMBER

Invoice line amount in global currency for PO matched invoice line
MATCH_LINE_AMT_B NUMBER

Invoice line amount in functional currency for PO matched invoice line
ITEM_ID NUMBER

Item identifier of the item being invoiced
ITEM_FK_KEY NUMBER

A foreign key generated by the warehouse that points to the item dimension at the lowest level.
INV_UNIT_PRICE_T NUMBER

Invoice unit price in transactional currency for PO matched invoice. Unit is in global unit of measure
INV_UNIT_PRICE_G NUMBER

Invoice unit price in global currency for PO matched invoice. Unit is in global unit of measure
INV_UNIT_PRICE_B NUMBER

Invoice unit price in functional currency for PO matched invoice. Unit is in global unit of measure
INV_SOURCE_FK_KEY NUMBER

A foreign key generated by the warehouse that points to the invoice source dimension at the lowest level.
INV_PRICE_VAR_AMT_T NUMBER

Amount of difference in transactional currency between an invoice line and PO due to PO price and AP price difference. For invoice line matched to PO only.
INV_PRICE_VAR_AMT_G NUMBER

Amount of difference in global currency between an invoice line and PO due to PO price and AP price difference. For invoice line matched to PO only.
INV_PRICE_VAR_AMT_B NUMBER

Amount of difference in functional currency between an invoice line and PO due to PO price and AP price difference. For invoice line matched to PO only.
INV_LINE_TYPE_FK_KEY NUMBER

A foreign key generated by the warehouse that points to the invoice line type dimension at the lowest level.
INV_LINE_COUNT NUMBER

Set to 1
INV_LINE_AMT_T NUMBER

Invoice line amount in transactional currency
INV_LINE_AMT_G NUMBER

Invoice line amount in global currency
INV_LINE_AMT_B NUMBER

Invoice line amount in functional currency
INV_FK_KEY NUMBER

A foreign key generated by the warehouse that points to the invoice type dimension at the lowest level.
INV_CURRENCY_FK_KEY NUMBER

A foreign key generated by the warehouse that points to the currency dimension at the lowest level.
INSTANCE_FK_KEY NUMBER

A foreign key generated by the warehouse that points to the instance dimension at the lowest level.
GL_ACCT9_FK_KEY NUMBER

System generated foreign key for the Accounting Flexfield dimension
GL_ACCT8_FK_KEY NUMBER

System generated foreign key for the Accounting Flexfield dimension
GL_ACCT7_FK_KEY NUMBER

System generated foreign key for the Accounting Flexfield dimension
GL_ACCT6_FK_KEY NUMBER

System generated foreign key for the Accounting Flexfield dimension
GL_ACCT5_FK_KEY NUMBER

System generated foreign key for the Accounting Flexfield dimension
GL_ACCT4_FK_KEY NUMBER

System generated foreign key for the Accounting Flexfield dimension
GL_ACCT3_FK_KEY NUMBER

System generated foreign key for the Accounting Flexfield dimension
GL_ACCT2_FK_KEY NUMBER

System generated foreign key for the Accounting Flexfield dimension
GL_ACCT1_FK_KEY NUMBER

System generated foreign key for the Accounting Flexfield dimension
GL_ACCT10_FK_KEY NUMBER

System generated foreign key for the Accounting Flexfield dimension
GEOGRAPHY_FK_KEY NUMBER

A foreign key generated by the warehouse that points to the geography dimension at the lowest level.
EXCHANGE_RATE_VAR NUMBER

Amount of difference between invoice line and PO due to exchange rate for invoice line matched to purhcase order
EXCHANGE_RATE NUMBER

Exchange rate for a foreign currency invoice
EMPLOYEE_FK_KEY NUMBER

A foreign key generated by the warehouse that points to the employee dimension at the lowest level.
CCID NUMBER

Invoice Accounting Flexfield identifier for accounts payable liability account
CATEGORY_ID NUMBER

Category identifier
CASH_JE_BATCH_ID NUMBER

Cash journal entry batch identifier
BATCH_ID NUMBER

Invoice batch identifier
AWT_GROUP_ID NUMBER

Withholding tax group identifier
ACCOUNTING_DATE_FK_KEY NUMBER

A foreign key generated by the warehouse that points to the time dimension at the lowest level.
VAT_CODE VARCHAR2 (15)
Value-added tax code
USER_FK9 VARCHAR2 (2000)
Foreign key for the user defined dimension
USER_FK8 VARCHAR2 (2000)
Foreign key for the user defined dimension
USER_FK7 VARCHAR2 (2000)
Foreign key for the user defined dimension
USER_FK6 VARCHAR2 (2000)
Foreign key for the user defined dimension
USER_FK5 VARCHAR2 (2000)
Foreign key for the user defined dimension
USER_FK3 VARCHAR2 (2000)
Foreign key for the user defined dimension
USER_FK4 VARCHAR2 (2000)
Foreign key for the user defined dimension
USER_FK2 VARCHAR2 (2000)
Foreign key for the user defined dimension
USER_FK10 VARCHAR2 (2000)
Foreign key for the user defined dimension
USER_FK1 VARCHAR2 (2000)
Foreign key for the user defined dimension
USER_ATTRIBUTE9 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE8 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE7 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE6 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE15 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE14 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE13 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE12 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE11 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE10 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
UOM_T_FK VARCHAR2 (120)
Foreign key to the unit of measure dimension based on transaction unit of measure.
UOM_G_FK VARCHAR2 (120)
Foreign key to the unit of measure base on the global unit of measure.
TYPE_1099 VARCHAR2 (10)
1099 type
SUPPLIER_FK VARCHAR2 (120)
Foreign key to the trading partner dimension.
SOB_FK VARCHAR2 (120)
Foreign key to the set of books dimension.
SIC_CODE_FK VARCHAR2 (120)
Foreign key to the standard industry code, SIC, dimension.
DUNS_FK VARCHAR2 (120)
Foreign key to the data universal numbering system, DUNS, dimension.
UNSPSC_FK VARCHAR2 (120)
Foreign key to the universal standard product and services classification code, UNSPSC, dimension.
ROW_ID ROWID (10)
Row identifier
POSTED_FLAG VARCHAR2 (1)
Flag that indicates if invoice line has been posted to the general ledger.
PAYMENT_TERM_FK VARCHAR2 (120)
Foreign key to the payment term dimension.
ORG_FK VARCHAR2 (120)
Foreign key to the organization dimension.
OPERATION_CODE VARCHAR2 (30)
Code used during warehouse collection
MATCH_STATUS_FLAG VARCHAR2 (1)
Approval status of the invoice line.
ITEM_FK VARCHAR2 (320)
Foreign key to the item dimension.
ITEM_DESCRIPTION VARCHAR2 (240)
Description of item being invoiced
INV_TYPE VARCHAR2 (25)
Invoice type
INV_SOURCE_FK VARCHAR2 (120)
Foreign key to the invoice source dimension
INV_NUM VARCHAR2 (50)
Invoice numebr of the invoice on hold
INV_LINE_TYPE_FK VARCHAR2 (120)
Foreign key to the invoice line type dimension
INV_LINE_PK VARCHAR2 (120)
Unique identifier
INV_LINE_DESCRIPTION VARCHAR2 (240)
Invoice line description
INV_FK VARCHAR2 (120)
Foreign key to the invoice type dimension
INV_CURRENCY_FK VARCHAR2 (120)
Foreign key to the invoice currency dimension
INSTANCE_FK VARCHAR2 (120)
Foreign key to the instance dimension
INSTANCE VARCHAR2 (40)
Instance identifier
INCOME_TAX_REGION VARCHAR2 (10)
Reporting region for invoice line for 1099 supplier
GL_ACCT9_FK VARCHAR2 (120)
Foreign key to the Accounting Flexfield dimensions
GL_ACCT8_FK VARCHAR2 (120)
Foreign key to the Accounting Flexfield dimensions
GL_ACCT7_FK VARCHAR2 (120)
Foreign key to the Accounting Flexfield dimensions
GL_ACCT6_FK VARCHAR2 (120)
Foreign key to the Accounting Flexfield dimensions
GL_ACCT5_FK VARCHAR2 (120)
Foreign key to the Accounting Flexfield dimensions
GL_ACCT4_FK VARCHAR2 (120)
Foreign key to the Accounting Flexfield dimensions
GL_ACCT3_FK VARCHAR2 (120)
Foreign key to the Accounting Flexfield dimensions
GL_ACCT2_FK VARCHAR2 (120)
Foreign key to the Accounting Flexfield dimensions
GL_ACCT1_FK VARCHAR2 (120)
Foreign key to the Accounting Flexfield dimensions
GL_ACCT10_FK VARCHAR2 (120)
Foreign key to the Accounting Flexfield dimensions
GEOGRAPHY_FK VARCHAR2 (120)
Foreign key to the geography dimension
EXCHANGE_RATE_TYPE VARCHAR2 (30)
Exchange rate type for a foreign currency invoice
ERROR_CODE VARCHAR2 (2000)
Code used to store error messages
ENCUMBERED_FLAG VARCHAR2 (1)
Flag indicating encumbrance status of invoice line
EMPLOYEE_FK VARCHAR2 (120)
Foreign key to the employee dimension
COLLECTION_STATUS VARCHAR2 (30)
Collection status code for the record
CASH_POSTED_FLAG VARCHAR2 (1)
Flag that indicates if invoice line has been posted to cash set of books
BASE_CURRENCY_CODE VARCHAR2 (15)
Functional currency of the set of books
AWT_FLAG VARCHAR2 (1)
Flag to determine if invoice line is subject to withholding tax. (Y, N, NULL)
ASSETS_TRACKING_FLAG VARCHAR2 (1)
Flag indicating if invoice line is tracked in Oracle Assets (Y/N)
AMT_INCLUDES_TAX_FLAG VARCHAR2 (1)
Flag indicating whether the amounts in MATCH_LINE_AMT and UNMATCH_LINE_AMT include tax
ACCRUAL_POSTED_FLAG VARCHAR2 (1)
Flag that indicates if payment has been posted to accrual set of books
ACCOUNTING_DATE_FK VARCHAR2 (120)
Foreign key to the accounting date dimension
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
INV_DATE DATE

Invoice date
EXCHANGE_DATE DATE

Date exchange rate is obtained from daily rates table.
CREATION_DATE DATE

Standard who column - date when this row was created.
ACCOUNTING_DATE DATE

Accounting date of the invoice line
APPROVAL_STATUS VARCHAR2 (25)
Status of manual authorization invoice approval
PO_NUMBER VARCHAR2 (20)
PO document number
DISCOUNT_AMT_T NUMBER

Discount amount in transaction currency
DISCOUNT_AMT_B NUMBER

Discount amount in base currency
DISCOUNT_AMT_G NUMBER

Discount amount in global currency
PROJECT_FK VARCHAR2 (120)
Reference to Project Dimension.
EXPENDITURE_TYPE VARCHAR2 (30)
Expenditure Type.
VOUCHER_NUMBER VARCHAR2 (50)
Voucher Number.
DOC_SEQUENCE_VALUE NUMBER

Document Sequence Value.
RCV_TRANSACTION_ID NUMBER (15)
Receipt Identifier
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT USER_MEASURE5
,      USER_MEASURE4
,      USER_MEASURE3
,      USER_MEASURE2
,      USER_MEASURE1
,      USER_FK9_KEY
,      USER_FK8_KEY
,      USER_FK7_KEY
,      USER_FK6_KEY
,      USER_FK5_KEY
,      USER_FK4_KEY
,      USER_FK3_KEY
,      USER_FK2_KEY
,      USER_FK1_KEY
,      USER_FK10_KEY
,      UOM_T_FK_KEY
,      UOM_G_FK_KEY
,      UNMATCH_LINE_COUNT
,      UNMATCH_LINE_AMT_T
,      UNMATCH_LINE_AMT_G
,      UNMATCH_LINE_AMT_B
,      TOTAL_VAR_AMT_T
,      TOTAL_VAR_AMT_G
,      TOTAL_VAR_AMT_B
,      TASK_ID
,      SUPPLIER_SITE_ID
,      SUPPLIER_FK_KEY
,      SOB_FK_KEY
,      SIC_CODE_FK_KEY
,      DUNS_FK_KEY
,      UNSPSC_FK_KEY
,      REQUEST_ID
,      QUANTITY_INVOICED_T
,      QUANTITY_INVOICED_G
,      QTY_VAR_AMT_T
,      QTY_VAR_AMT_G
,      QTY_VAR_AMT_B
,      PROJECT_ID
,      PO_UNIT_PRICE_T
,      PO_UNIT_PRICE_G
,      PO_UNIT_PRICE_B
,      PO_DISTRIBUTION_ID
,      PO_AMT_T
,      PO_AMT_G
,      PO_AMT_B
,      POSTED_AMT_T
,      POSTED_AMT_G
,      POSTED_AMT_B
,      PAYMENT_TERM_FK_KEY
,      ORG_FK_KEY
,      MATCH_LINE_COUNT
,      MATCH_LINE_AMT_T
,      MATCH_LINE_AMT_G
,      MATCH_LINE_AMT_B
,      ITEM_ID
,      ITEM_FK_KEY
,      INV_UNIT_PRICE_T
,      INV_UNIT_PRICE_G
,      INV_UNIT_PRICE_B
,      INV_SOURCE_FK_KEY
,      INV_PRICE_VAR_AMT_T
,      INV_PRICE_VAR_AMT_G
,      INV_PRICE_VAR_AMT_B
,      INV_LINE_TYPE_FK_KEY
,      INV_LINE_COUNT
,      INV_LINE_AMT_T
,      INV_LINE_AMT_G
,      INV_LINE_AMT_B
,      INV_FK_KEY
,      INV_CURRENCY_FK_KEY
,      INSTANCE_FK_KEY
,      GL_ACCT9_FK_KEY
,      GL_ACCT8_FK_KEY
,      GL_ACCT7_FK_KEY
,      GL_ACCT6_FK_KEY
,      GL_ACCT5_FK_KEY
,      GL_ACCT4_FK_KEY
,      GL_ACCT3_FK_KEY
,      GL_ACCT2_FK_KEY
,      GL_ACCT1_FK_KEY
,      GL_ACCT10_FK_KEY
,      GEOGRAPHY_FK_KEY
,      EXCHANGE_RATE_VAR
,      EXCHANGE_RATE
,      EMPLOYEE_FK_KEY
,      CCID
,      CATEGORY_ID
,      CASH_JE_BATCH_ID
,      BATCH_ID
,      AWT_GROUP_ID
,      ACCOUNTING_DATE_FK_KEY
,      VAT_CODE
,      USER_FK9
,      USER_FK8
,      USER_FK7
,      USER_FK6
,      USER_FK5
,      USER_FK3
,      USER_FK4
,      USER_FK2
,      USER_FK10
,      USER_FK1
,      USER_ATTRIBUTE9
,      USER_ATTRIBUTE8
,      USER_ATTRIBUTE7
,      USER_ATTRIBUTE6
,      USER_ATTRIBUTE5
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE15
,      USER_ATTRIBUTE14
,      USER_ATTRIBUTE13
,      USER_ATTRIBUTE12
,      USER_ATTRIBUTE11
,      USER_ATTRIBUTE10
,      USER_ATTRIBUTE1
,      UOM_T_FK
,      UOM_G_FK
,      TYPE_1099
,      SUPPLIER_FK
,      SOB_FK
,      SIC_CODE_FK
,      DUNS_FK
,      UNSPSC_FK
,      ROW_ID
,      POSTED_FLAG
,      PAYMENT_TERM_FK
,      ORG_FK
,      OPERATION_CODE
,      MATCH_STATUS_FLAG
,      ITEM_FK
,      ITEM_DESCRIPTION
,      INV_TYPE
,      INV_SOURCE_FK
,      INV_NUM
,      INV_LINE_TYPE_FK
,      INV_LINE_PK
,      INV_LINE_DESCRIPTION
,      INV_FK
,      INV_CURRENCY_FK
,      INSTANCE_FK
,      INSTANCE
,      INCOME_TAX_REGION
,      GL_ACCT9_FK
,      GL_ACCT8_FK
,      GL_ACCT7_FK
,      GL_ACCT6_FK
,      GL_ACCT5_FK
,      GL_ACCT4_FK
,      GL_ACCT3_FK
,      GL_ACCT2_FK
,      GL_ACCT1_FK
,      GL_ACCT10_FK
,      GEOGRAPHY_FK
,      EXCHANGE_RATE_TYPE
,      ERROR_CODE
,      ENCUMBERED_FLAG
,      EMPLOYEE_FK
,      COLLECTION_STATUS
,      CASH_POSTED_FLAG
,      BASE_CURRENCY_CODE
,      AWT_FLAG
,      ASSETS_TRACKING_FLAG
,      AMT_INCLUDES_TAX_FLAG
,      ACCRUAL_POSTED_FLAG
,      ACCOUNTING_DATE_FK
,      LAST_UPDATE_DATE
,      INV_DATE
,      EXCHANGE_DATE
,      CREATION_DATE
,      ACCOUNTING_DATE
,      APPROVAL_STATUS
,      PO_NUMBER
,      DISCOUNT_AMT_T
,      DISCOUNT_AMT_B
,      DISCOUNT_AMT_G
,      PROJECT_FK
,      EXPENDITURE_TYPE
,      VOUCHER_NUMBER
,      DOC_SEQUENCE_VALUE
,      RCV_TRANSACTION_ID
FROM FII.FII_AP_INV_LINES_FSTG;

Dependencies

[top of page]

FII.FII_AP_INV_LINES_FSTG does not reference any database object

FII.FII_AP_INV_LINES_FSTG is referenced by following:

SchemaAPPS
SynonymFII_AP_INV_LINES_FSTG