DBA Data[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: ViewFII.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
Name Datatype Length Mandatory Comments
APPROVAL_STATUS VARCHAR2 (25)
SEQ_ID NUMBER (15)
INV_LINE_PK VARCHAR2 (194)
UOM_G_FK VARCHAR2 (4000)
UOM_T_FK VARCHAR2 (4000)
ACCOUNTING_DATE_FK VARCHAR2 (76)
EMPLOYEE_FK VARCHAR2 (85)
GEOGRAPHY_FK VARCHAR2 (126)
SUPPLIER_FK VARCHAR2 (126)
INV_FK VARCHAR2 (112)
INV_CURRENCY_FK VARCHAR2 (15)
INSTANCE_FK VARCHAR2 (30)
INV_SOURCE_FK VARCHAR2 (25)
ORG_FK VARCHAR2 (71)
PAYMENT_TERM_FK VARCHAR2 (74)
SOB_FK VARCHAR2 (71)
SIC_CODE_FK VARCHAR2 (25)
DUNS_FK CHAR (6)
UNSPSC_FK CHAR (6)
ITEM_FK VARCHAR2 (366)
INV_LINE_TYPE_FK VARCHAR2 (25)
INSTANCE VARCHAR2 (30)
MATCH_LINE_COUNT NUMBER

UNMATCH_LINE_COUNT NUMBER

INV_LINE_COUNT NUMBER

MATCH_LINE_AMT_T NUMBER

MATCH_LINE_AMT_B NUMBER

MATCH_LINE_AMT_G NUMBER

UNMATCH_LINE_AMT_T NUMBER

UNMATCH_LINE_AMT_B NUMBER

UNMATCH_LINE_AMT_G NUMBER

INV_LINE_AMT_T NUMBER

INV_LINE_AMT_B NUMBER

INV_LINE_AMT_G NUMBER

INV_UNIT_PRICE_T NUMBER

INV_UNIT_PRICE_B NUMBER

INV_UNIT_PRICE_G NUMBER

PO_UNIT_PRICE_B NUMBER

PO_UNIT_PRICE_G NUMBER

PO_UNIT_PRICE_T NUMBER

TOTAL_VAR_AMT_T NUMBER

TOTAL_VAR_AMT_B NUMBER

TOTAL_VAR_AMT_G NUMBER

ACCOUNTING_DATE DATE

SUPPLIER_SITE_ID NUMBER (15)
INV_NUM VARCHAR2 (50)
INV_TYPE VARCHAR2 (25)
BASE_CURRENCY_CODE VARCHAR2 (15)
ITEM_ID NUMBER

CATEGORY_ID NUMBER

ITEM_DESCRIPTION VARCHAR2 (240)
PO_DISTRIBUTION_ID NUMBER

ACCRUAL_POSTED_FLAG VARCHAR2 (1)
AMT_INCLUDES_TAX_FLAG VARCHAR2 (1)
ASSETS_TRACKING_FLAG VARCHAR2 (1)
CASH_POSTED_FLAG VARCHAR2 (1)
POSTED_FLAG VARCHAR2 (1)
MATCH_STATUS_FLAG VARCHAR2 (1)
INV_PRICE_VAR_AMT_T NUMBER

INV_PRICE_VAR_AMT_B NUMBER

INV_PRICE_VAR_AMT_G NUMBER

QTY_VAR_AMT_T NUMBER

QTY_VAR_AMT_B NUMBER

QTY_VAR_AMT_G NUMBER

QUANTITY_INVOICED_T NUMBER

QUANTITY_INVOICED_G NUMBER

BATCH_ID NUMBER (15)
INV_LINE_DESCRIPTION VARCHAR2 (240)
EXCHANGE_RATE_VAR NUMBER

INCOME_TAX_REGION VARCHAR2 (10)
INV_DATE DATE

TYPE_1099 VARCHAR2 (10)
VAT_CODE VARCHAR2 (15)
ENCUMBERED_FLAG VARCHAR2 (1)
PROJECT_ID NUMBER (15)
TASK_ID NUMBER (15)
EXCHANGE_RATE NUMBER

EXCHANGE_RATE_TYPE VARCHAR2 (30)
EXCHANGE_DATE DATE

CASH_JE_BATCH_ID NUMBER (15)
AWT_FLAG VARCHAR2 (1)
AWT_GROUP_ID NUMBER (15)
POSTED_AMT_T NUMBER

POSTED_AMT_B NUMBER

POSTED_AMT_G NUMBER

PO_AMT_T NUMBER

PO_AMT_B NUMBER

PO_AMT_G NUMBER

LAST_UPDATE_DATE DATE

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

LAST_UPDATE_DATE2 DATE

LAST_UPDATE_DATE3 DATE

LAST_UPDATE_DATE4 DATE

CREATION_DATE DATE

Standard who column - date when this row was created.
CCID NUMBER (15)
SET_OF_BOOKS_ID NUMBER (15)
CHART_OF_ACCOUNTS_ID NUMBER (15)
GLOBAL_CURRENCY_RATE NUMBER

PO_NUMBER VARCHAR2 (20)
GL_ACCT1_FK VARCHAR2 (3775)
GL_ACCT2_FK VARCHAR2 (3775)
GL_ACCT3_FK VARCHAR2 (3775)
GL_ACCT4_FK VARCHAR2 (3775)
GL_ACCT5_FK VARCHAR2 (3775)
GL_ACCT6_FK VARCHAR2 (3775)
GL_ACCT7_FK VARCHAR2 (3775)
GL_ACCT8_FK VARCHAR2 (3775)
GL_ACCT9_FK VARCHAR2 (3775)
GL_ACCT10_FK VARCHAR2 (3775)
USER_MEASURE1 NUMBER

USER_MEASURE2 NUMBER

USER_MEASURE3 NUMBER

USER_MEASURE4 NUMBER

USER_MEASURE5 NUMBER

USER_ATTRIBUTE1 VARCHAR2 (0)
USER_ATTRIBUTE2 VARCHAR2 (0)
USER_ATTRIBUTE3 VARCHAR2 (0)
USER_ATTRIBUTE4 VARCHAR2 (0)
USER_ATTRIBUTE5 VARCHAR2 (0)
USER_ATTRIBUTE6 VARCHAR2 (0)
USER_ATTRIBUTE7 VARCHAR2 (0)
USER_ATTRIBUTE8 VARCHAR2 (0)
USER_ATTRIBUTE9 VARCHAR2 (0)
USER_ATTRIBUTE10 VARCHAR2 (0)
USER_FK1 VARCHAR2 (0)
USER_FK2 VARCHAR2 (0)
USER_FK3 VARCHAR2 (0)
USER_FK4 VARCHAR2 (0)
USER_FK5 VARCHAR2 (0)
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)
OLD_DIST_LINE_NUMBER NUMBER (15)
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.FII_AP_INV_LINES_FCV references the following:

SchemaAPPS
PL/SQL PackageEDW_CURRENCY - show dependent code
PL/SQL PackageEDW_UTIL - show dependent code
ViewFIIBV_AP_INV_LINES_FCV
PL/SQL PackageFII_FLEX_MAPPING - show dependent code
APPS.FII_AP_INV_LINES_FCV is referenced by following:

SchemaAPPS
Package BodyFII_AP_INV_LINES_F_C - show dependent code