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

VIEW: APPS.POA_FII_AP_INV_LINES_F_V

Object Details
Object Name: POA_FII_AP_INV_LINES_F_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
SUPPLIER_FK_KEY NUMBER

A foreign key generated by the warehouse that points to the trading partner dimension at the lowest level.
ACCOUNTING_DATE_FK_KEY NUMBER

A foreign key generated by the warehouse that points to the time 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.
ORG_FK_KEY NUMBER

A foreign key generated by the warehouse that points to the organization 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.
UOM_T_FK_KEY NUMBER

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

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

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

A foreign key generated by the warehouse that points to the item 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.
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.
EMPLOYEE_FK_KEY NUMBER

A foreign key generated by the warehouse that points to the employee dimension at the lowest level.
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
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
SOB_FK_KEY NUMBER

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

A foreign key generated by the warehouse that points to the geography 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.
PAYMENT_TERM_FK_KEY NUMBER

System generated foreign key for the payment term dimension
UOM_G_FK_KEY NUMBER

System generated foreign key for global unit of measure dimension
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_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
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 the 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 corresponding matched invoice.
TASK_ID NUMBER

Task identifier
SUPPLIER_SITE_ID NUMBER

Supplier site identifier
QUANTITY_INVOICED_T NUMBER

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

Quantity in global unit of measure billed for PO matched invoice line
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 invoice 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

Project identifier
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 base 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 general ledger in the transactional currency
POSTED_AMT_G NUMBER

Amount posted to general ledger in the global currency
POSTED_AMT_B NUMBER

Amount posted to general ledger in the functional currency
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
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_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_PK_KEY NUMBER

System generated foreign key for the Invoice Line dimension
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
EXCHANGE_RATE_VAR_AMT NUMBER

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

Exchange rate for a foreign currency invoice
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
VAT_CODE VARCHAR2 (15)
Value-added tax code
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
TYPE_1099 VARCHAR2 (10)
1099 Type
POSTED_FLAG VARCHAR2 (1)
Flag that indicates if payment has been posted (Y/N)
MATCH_STATUS_FLAG VARCHAR2 (1)
Approval status of the invoice line
ITEM_DESCRIPTION VARCHAR2 (240)
Description of the item being invoiced
INV_TYPE VARCHAR2 (25)
Invoice type of the invoice on hold
INV_NUM VARCHAR2 (50)
Invoice number of the invoice on hold
INV_LINE_PK VARCHAR2 (40)
Unique identifier
INV_LINE_DESCRIPTION VARCHAR2 (240)
Invoice line description
INSTANCE VARCHAR2 (40)
Instance identifier
INCOME_TAX_REGION VARCHAR2 (10)
Reporting region for invoice line for the 1099 supplier
EXCHANGE_RATE_TYPE VARCHAR2 (30)
Exchange rate type for a foreign currency invoice
ENCUMBERED_FLAG VARCHAR2 (1)
Flag indicating encumbrance status of invoice line.
CASH_POSTED_FLAG VARCHAR2 (1)
Flag that indicates if payment has been posted (Y/N)
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 (Y/N)
LAST_UPDATE_DATE DATE

Standard Who column
INV_DATE DATE

Invoice date
EXCHANGE_DATE DATE

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

Standard Who column
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_KEY NUMBER

Foreign Key generated by warehouse that points to project dimension.
EXPENDITURE_TYPE VARCHAR2 (30)
Expenditure Type.
VOUCHER_NUMBER VARCHAR2 (50)
Voucher Number.
DOC_SEQUENCE_VALUE NUMBER

Document Sequence Value
Query Text

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


SELECT SUPPLIER_FK_KEY
,      ACCOUNTING_DATE_FK_KEY
,      SIC_CODE_FK_KEY
,      DUNS_FK_KEY
,      ORG_FK_KEY
,      UNSPSC_FK_KEY
,      UOM_T_FK_KEY
,      INV_FK_KEY
,      INV_SOURCE_FK_KEY
,      ITEM_FK_KEY
,      INSTANCE_FK_KEY
,      INV_LINE_TYPE_FK_KEY
,      EMPLOYEE_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
,      GL_ACCT9_FK_KEY
,      GL_ACCT8_FK_KEY
,      SOB_FK_KEY
,      GEOGRAPHY_FK_KEY
,      INV_CURRENCY_FK_KEY
,      PAYMENT_TERM_FK_KEY
,      UOM_G_FK_KEY
,      USER_MEASURE5
,      USER_MEASURE4
,      USER_MEASURE3
,      USER_MEASURE2
,      USER_MEASURE1
,      USER_FK5_KEY
,      USER_FK4_KEY
,      USER_FK3_KEY
,      USER_FK2_KEY
,      USER_FK1_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
,      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
,      MATCH_LINE_COUNT
,      MATCH_LINE_AMT_T
,      MATCH_LINE_AMT_G
,      MATCH_LINE_AMT_B
,      ITEM_ID
,      INV_UNIT_PRICE_T
,      INV_UNIT_PRICE_G
,      INV_UNIT_PRICE_B
,      INV_PRICE_VAR_AMT_T
,      INV_PRICE_VAR_AMT_G
,      INV_PRICE_VAR_AMT_B
,      INV_LINE_PK_KEY
,      INV_LINE_COUNT
,      INV_LINE_AMT_T
,      INV_LINE_AMT_G
,      INV_LINE_AMT_B
,      EXCHANGE_RATE_VAR_AMT
,      EXCHANGE_RATE
,      CCID
,      CATEGORY_ID
,      CASH_JE_BATCH_ID
,      BATCH_ID
,      AWT_GROUP_ID
,      VAT_CODE
,      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
,      TYPE_1099
,      POSTED_FLAG
,      MATCH_STATUS_FLAG
,      ITEM_DESCRIPTION
,      INV_TYPE
,      INV_NUM
,      INV_LINE_PK
,      INV_LINE_DESCRIPTION
,      INSTANCE
,      INCOME_TAX_REGION
,      EXCHANGE_RATE_TYPE
,      ENCUMBERED_FLAG
,      CASH_POSTED_FLAG
,      BASE_CURRENCY_CODE
,      AWT_FLAG
,      ASSETS_TRACKING_FLAG
,      AMT_INCLUDES_TAX_FLAG
,      ACCRUAL_POSTED_FLAG
,      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_KEY
,      EXPENDITURE_TYPE
,      VOUCHER_NUMBER
,      DOC_SEQUENCE_VALUE
FROM APPS.POA_FII_AP_INV_LINES_F_V;

Dependencies

[top of page]

APPS.POA_FII_AP_INV_LINES_F_V references the following:

SchemaAPPS
SynonymFII_AP_INV_LINES_F
APPS.POA_FII_AP_INV_LINES_F_V is referenced by following:

SchemaAPPS
ViewPOA_PMF_MIN_VIEW_SP
ViewPOA_REP_AP_LKG1
ViewPOA_REP_AP_LKG2
ViewPOA_REP_AP_SPEND_V