[Home] [Help] [Dependency Information]

VIEW: APPS.FII_AP_INV_LINES_FCV

Object Details

Object Name:	FII_AP_INV_LINES_FCV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FII.FII_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

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
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      USER_ATTRIBUTE6
,      USER_ATTRIBUTE7
,      USER_ATTRIBUTE8
,      USER_ATTRIBUTE9
,      USER_ATTRIBUTE10
,      USER_FK1
,      USER_FK2
,      USER_FK3
,      USER_FK4
,      USER_FK5
,      PROJECT_FK
,      EXPENDITURE_TYPE
,      VOUCHER_NUMBER
,      DOC_SEQUENCE_VALUE
,      RCV_TRANSACTION_ID
,      INVOICE_DISTRIBUTION_ID
,      OLD_DIST_LINE_NUMBER
FROM APPS.FII_AP_INV_LINES_FCV;

Dependencies

[top of page]

APPS

EDW_CURRENCY - show dependent code

EDW_UTIL - show dependent code

FIIBV_AP_INV_LINES_FCV

FII_FLEX_MAPPING - show dependent code

APPS

FII_AP_INV_LINES_F_C - show dependent code