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

VIEW: APPS.FIIBV_AP_INV_LINES_FCV

Object Details
Object Name: FIIBV_AP_INV_LINES_FCV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFII.FIIBV_AP_INV_LINES_FCV
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
APPROVAL_STATUS VARCHAR2 (25)
Status of manual authorization invoice approval
SEQ_ID NUMBER (15)
This column is for internal use only
INV_LINE_PK VARCHAR2 (194)
Unique identifier
UOM_G_FK VARCHAR2 (4000)
Foreign key to the unit of measure base on the global unit of measure.
UOM_T_FK VARCHAR2 (4000)
Foreign key to the unit of measure dimension based on transaction unit of measure.
ACCOUNTING_DATE_FK VARCHAR2 (76)
Foreign key to the accounting date dimension
EMPLOYEE_FK VARCHAR2 (85)
Foreign key to the employee dimension
GEOGRAPHY_FK VARCHAR2 (126)
Foreign key to the geography dimension
SUPPLIER_FK VARCHAR2 (126)
Foreign key to the trading partner dimension.
INV_FK VARCHAR2 (112)
Foreign key to the invoice type dimension
INV_CURRENCY_FK VARCHAR2 (15)
Foreign key to the invoice currency dimension
INSTANCE_FK VARCHAR2 (30)
Foreign key to the instance dimension
INV_SOURCE_FK VARCHAR2 (25)
Foreign key to the invoice source dimension
ORG_FK VARCHAR2 (71)
Foreign key to the organization dimension.
PAYMENT_TERM_FK VARCHAR2 (74)
Foreign key to the payment term dimension.
SOB_FK VARCHAR2 (71)
Foreign key to the set of books dimension.
SIC_CODE_FK VARCHAR2 (25)
Foreign key to the standard industry code, SIC, dimension.
DUNS_FK CHAR (6)
Foreign key to the data universal numbering system, DUNS, dimension.
UNSPSC_FK CHAR (6)
Foreign key to the universal standard product and services classification code, UNSPSC, dimension.
ITEM_FK VARCHAR2 (366)
Foreign key to the item dimension.
INV_LINE_TYPE_FK VARCHAR2 (25)
Foreign key to the invoice line type dimension
INSTANCE VARCHAR2 (30)
Instance identifier
MATCH_LINE_COUNT NUMBER

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

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

Set to 1
MATCH_LINE_AMT_T NUMBER

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

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

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

Invoice line amount in transactional 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.
UNMATCH_LINE_AMT_G NUMBER

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

Invoice line amount in transactional currency
INV_LINE_AMT_B NUMBER

Invoice line amount in functional currency
INV_LINE_AMT_G NUMBER

Invoice line amount in global currency
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_B NUMBER

Invoice unit price in functional 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
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_UNIT_PRICE_G NUMBER

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

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

Total variance amount in transactional currency between 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.
TOTAL_VAR_AMT_G NUMBER

Total variance amount in global currency between the PO and the corresponding matched invoice.
ACCOUNTING_DATE DATE

Accounting date of the invoice line
SUPPLIER_SITE_ID NUMBER (15)
Identifier for supplier site
INV_NUM VARCHAR2 (50)
Invoice numebr of the invoice on hold
INV_TYPE VARCHAR2 (25)
Invoice type
BASE_CURRENCY_CODE VARCHAR2 (15)
Functional currency of the set of books
ITEM_ID NUMBER

Item identifier of the item being invoiced
CATEGORY_ID NUMBER

Category identifier
ITEM_DESCRIPTION VARCHAR2 (240)
Description of item being invoiced
PO_DISTRIBUTION_ID NUMBER

PO distribution identifier which is matched to this invoice line
ACCRUAL_POSTED_FLAG VARCHAR2 (1)
Flag that indicates if payment has been posted to accrual set of books
AMT_INCLUDES_TAX_FLAG VARCHAR2 (1)
Flag indicating whether the amounts in MATCH_LINE_AMT and UNMATCH_LINE_AMT include tax
ASSETS_TRACKING_FLAG VARCHAR2 (1)
Flag indicating if invoice line is tracked in Oracle Assets Y or N
CASH_POSTED_FLAG VARCHAR2 (1)
Flag that indicates if invoice line has been posted to cash set of books
POSTED_FLAG VARCHAR2 (1)
Flag that indicates if invoice line has been posted to the general ledger.
MATCH_STATUS_FLAG VARCHAR2 (1)
Approval status of the invoice line.
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_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_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.
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_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.
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.
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
BATCH_ID NUMBER (15)
Invoice batch identifier
INV_LINE_DESCRIPTION VARCHAR2 (240)
Invoice line description
EXCHANGE_RATE_VAR NUMBER

Amount of difference between invoice line and PO due to exchange rate for invoice line matched to purhcase order
INCOME_TAX_REGION VARCHAR2 (10)
Reporting region for invoice line for 1099 supplier
INV_DATE DATE

Invoice date
TYPE_1099 VARCHAR2 (10)
1099 type
VAT_CODE VARCHAR2 (15)
Value-added tax code
ENCUMBERED_FLAG VARCHAR2 (1)
Flag indicating encumbrance status of invoice line
PROJECT_ID NUMBER (15)
Identifier used for a project used to build Accounting Flexfield for project-related invoice line.
TASK_ID NUMBER (15)
Identifier for project task used to build the default Accounting Flexifield.
EXCHANGE_RATE NUMBER

Exchange rate for a foreign currency invoice
EXCHANGE_RATE_TYPE VARCHAR2 (30)
Exchange rate type for a foreign currency invoice
EXCHANGE_DATE DATE

Date exchange rate is obtained from daily rates table.
CASH_JE_BATCH_ID NUMBER (15)
Cash journal entry batch identifier
AWT_FLAG VARCHAR2 (1)
Flag to determine if invoice line is subject to withholding tax. (Y, N, NULL)
AWT_GROUP_ID NUMBER (15)
Withholding tax group identifier
POSTED_AMT_T NUMBER

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

Amount posted to the general ledger in functional currency
POSTED_AMT_G NUMBER

Amount posted to the general ledger in global currency
PO_AMT_T NUMBER

PO amount in transactional 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.
PO_AMT_G NUMBER

PO amount in global currency matched to this invoice line. For PO matched invoice line only.
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATE_DATE1 DATE

Standard Who column
LAST_UPDATE_DATE2 DATE

Standard Who column
LAST_UPDATE_DATE3 DATE

Standard Who column
LAST_UPDATE_DATE4 DATE

Standard Who column
CREATION_DATE DATE

Standard Who Column
CCID NUMBER (15)
Invoice Accounting Flexfield identifier for accounts payable liability account
SET_OF_BOOKS_ID NUMBER (15)
Set of Books identifier
CHART_OF_ACCOUNTS_ID NUMBER (15)
Chart of accounts identifier
GLOBAL_CURRENCY_RATE NUMBER

Exchange rate for a foreign currency invoice
PO_NUMBER VARCHAR2 (20)
PO document number
GL_ACCT1_FK CHAR (6)
Foreign key to the Accounting Flexfield dimensions
GL_ACCT2_FK CHAR (6)
Foreign key to the Accounting Flexfield dimensions
GL_ACCT3_FK CHAR (6)
Foreign key to the Accounting Flexfield dimensions
GL_ACCT4_FK CHAR (6)
Foreign key to the Accounting Flexfield dimensions
GL_ACCT5_FK CHAR (6)
Foreign key to the Accounting Flexfield dimensions
GL_ACCT6_FK CHAR (6)
Foreign key to the Accounting Flexfield dimensions
GL_ACCT7_FK CHAR (6)
Foreign key to the Accounting Flexfield dimensions
GL_ACCT8_FK CHAR (6)
Foreign key to the Accounting Flexfield dimensions
GL_ACCT9_FK CHAR (6)
Foreign key to the Accounting Flexfield dimensions
GL_ACCT10_FK CHAR (6)
Foreign key to the Accounting Flexfield dimensions
_KF:GL_ACCT_NUM:ACCT:_EDW CHAR (17)
This column is for internal use only
_DF:IVD:_EDW CHAR (38)
This column is for internal use only
_DF:IDJ:_EDW CHAR (38)
This column is for internal use only
_DF:INV:_EDW CHAR (24)
This column is for internal use only
_DF:IVJ:_EDW CHAR (24)
This column is for internal use only
PROJECT_FK VARCHAR2 (78)
EXPENDITURE_TYPE VARCHAR2 (30)
VOUCHER_NUMBER VARCHAR2 (50)
DOC_SEQUENCE_VALUE NUMBER

RCV_TRANSACTION_ID NUMBER (15)
INVOICE_DISTRIBUTION_ID NUMBER (15)
This column is for internal use only
OLD_DIST_LINE_NUMBER NUMBER (15)
This column is for internal use only
Query Text

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


SELECT APPROVAL_STATUS
,      SEQ_ID
,      INV_LINE_PK
,      UOM_G_FK
,      UOM_T_FK
,      ACCOUNTING_DATE_FK
,      EMPLOYEE_FK
,      GEOGRAPHY_FK
,      SUPPLIER_FK
,      INV_FK
,      INV_CURRENCY_FK
,      INSTANCE_FK
,      INV_SOURCE_FK
,      ORG_FK
,      PAYMENT_TERM_FK
,      SOB_FK
,      SIC_CODE_FK
,      DUNS_FK
,      UNSPSC_FK
,      ITEM_FK
,      INV_LINE_TYPE_FK
,      INSTANCE
,      MATCH_LINE_COUNT
,      UNMATCH_LINE_COUNT
,      INV_LINE_COUNT
,      MATCH_LINE_AMT_T
,      MATCH_LINE_AMT_B
,      MATCH_LINE_AMT_G
,      UNMATCH_LINE_AMT_T
,      UNMATCH_LINE_AMT_B
,      UNMATCH_LINE_AMT_G
,      INV_LINE_AMT_T
,      INV_LINE_AMT_B
,      INV_LINE_AMT_G
,      INV_UNIT_PRICE_T
,      INV_UNIT_PRICE_B
,      INV_UNIT_PRICE_G
,      PO_UNIT_PRICE_B
,      PO_UNIT_PRICE_G
,      PO_UNIT_PRICE_T
,      TOTAL_VAR_AMT_T
,      TOTAL_VAR_AMT_B
,      TOTAL_VAR_AMT_G
,      ACCOUNTING_DATE
,      SUPPLIER_SITE_ID
,      INV_NUM
,      INV_TYPE
,      BASE_CURRENCY_CODE
,      ITEM_ID
,      CATEGORY_ID
,      ITEM_DESCRIPTION
,      PO_DISTRIBUTION_ID
,      ACCRUAL_POSTED_FLAG
,      AMT_INCLUDES_TAX_FLAG
,      ASSETS_TRACKING_FLAG
,      CASH_POSTED_FLAG
,      POSTED_FLAG
,      MATCH_STATUS_FLAG
,      INV_PRICE_VAR_AMT_T
,      INV_PRICE_VAR_AMT_B
,      INV_PRICE_VAR_AMT_G
,      QTY_VAR_AMT_T
,      QTY_VAR_AMT_B
,      QTY_VAR_AMT_G
,      QUANTITY_INVOICED_T
,      QUANTITY_INVOICED_G
,      BATCH_ID
,      INV_LINE_DESCRIPTION
,      EXCHANGE_RATE_VAR
,      INCOME_TAX_REGION
,      INV_DATE
,      TYPE_1099
,      VAT_CODE
,      ENCUMBERED_FLAG
,      PROJECT_ID
,      TASK_ID
,      EXCHANGE_RATE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_DATE
,      CASH_JE_BATCH_ID
,      AWT_FLAG
,      AWT_GROUP_ID
,      POSTED_AMT_T
,      POSTED_AMT_B
,      POSTED_AMT_G
,      PO_AMT_T
,      PO_AMT_B
,      PO_AMT_G
,      LAST_UPDATE_DATE
,      LAST_UPDATE_DATE1
,      LAST_UPDATE_DATE2
,      LAST_UPDATE_DATE3
,      LAST_UPDATE_DATE4
,      CREATION_DATE
,      CCID
,      SET_OF_BOOKS_ID
,      CHART_OF_ACCOUNTS_ID
,      GLOBAL_CURRENCY_RATE
,      PO_NUMBER
,      GL_ACCT1_FK
,      GL_ACCT2_FK
,      GL_ACCT3_FK
,      GL_ACCT4_FK
,      GL_ACCT5_FK
,      GL_ACCT6_FK
,      GL_ACCT7_FK
,      GL_ACCT8_FK
,      GL_ACCT9_FK
,      GL_ACCT10_FK
,      _KF:GL_ACCT_NUM:ACCT:_EDW
,      _DF:IVD:_EDW
,      _DF:IDJ:_EDW
,      _DF:INV:_EDW
,      _DF:IVJ:_EDW
,      PROJECT_FK
,      EXPENDITURE_TYPE
,      VOUCHER_NUMBER
,      DOC_SEQUENCE_VALUE
,      RCV_TRANSACTION_ID
,      INVOICE_DISTRIBUTION_ID
,      OLD_DIST_LINE_NUMBER
FROM APPS.FIIBV_AP_INV_LINES_FCV;

Dependencies

[top of page]

APPS.FIIBV_AP_INV_LINES_FCV references the following:

SchemaAPPS
SynonymAP_INVOICES_ALL
SynonymAP_INVOICE_DISTRIBUTIONS_ALL
PL/SQL PackageEDW_CURRENCY - show dependent code
SynonymEDW_LOCAL_INSTANCE
SynonymEDW_LOCAL_SYSTEM_PARAMETERS
PL/SQL PackageEDW_UTIL - show dependent code
SynonymFII_AP_TMP_LINE_PK
SynonymFINANCIALS_SYSTEM_PARAMS_ALL
SynonymFND_USER
SynonymGL_CODE_COMBINATIONS
ViewGL_SETS_OF_BOOKS
SynonymMTL_UNITS_OF_MEASURE
SynonymPO_DISTRIBUTIONS_ALL
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL
ViewPO_VENDORS
APPS.FIIBV_AP_INV_LINES_FCV is referenced by following:

SchemaAPPS
ViewFII_AP_INV_LINES_FCV