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

VIEW: APPS.POA_FII_AP_HOLD_DATA_F_V

Object Details
Object Name: POA_FII_AP_HOLD_DATA_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.
HOLD_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.
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.
RELEASE_FK_KEY NUMBER

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

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

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

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

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

A foreign key generated by the warehouse that points to the hold 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
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

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

Invoice supplier site identifier
INV_AMT_T NUMBER

Invoice amount in transactional currency
INV_AMT_G NUMBER

Invoice amount in global currency
INV_AMT_B NUMBER

Invoice amount in base currency
HOLD_DATA_PK_KEY NUMBER

A foreign key generated by the warehouse that points to the hold data dimension at the lowest level.
HOLD_COUNT NUMBER

Set to 1
HELD_BY NUMBER

Employee who placed the hold on the invoice.
CCID NUMBER

Invoice Accounting Flexfield identifier for accounts payable liability account
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
RELEASE_REASON VARCHAR2 (240)
The release reason for the invoice on hold.
RELEASE_LOOKUP_CODE VARCHAR2 (25)
Name of release code
INV_TYPE VARCHAR2 (25)
Invoice type of invoice being held.
INV_SOURCE VARCHAR2 (25)
Invoice source of invoice being held.
INV_NUM VARCHAR2 (50)
Invoice number of invoice being held.
INSTANCE VARCHAR2 (40)
Instance identifier
HOLD_REASON VARCHAR2 (240)
Reason for hold being placed
HOLD_LOOKUP_CODE VARCHAR2 (25)
Name of the hold code
HOLD_DATA_PK VARCHAR2 (300)
Unique Identifier
LAST_UPDATE_DATE DATE

Standard Who column
CREATION_DATE DATE

Standard Who column
HOLD_DATE DATE
Yes Date the hold was placed
HOLD_RELEASE_COUNT VARCHAR2 (240) Yes Set to 1 if this hold has been released, 0 otherwise.
HOLD_RELEASE_DAYS NUMBER

The duration of this hold in number of days.
Query Text

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


SELECT SUPPLIER_FK_KEY
,      HOLD_DATE_FK_KEY
,      SIC_CODE_FK_KEY
,      DUNS_FK_KEY
,      RELEASE_FK_KEY
,      ORG_FK_KEY
,      INV_FK_KEY
,      INV_SOURCE_FK_KEY
,      INSTANCE_FK_KEY
,      HOLD_BY_EMPLOYEE_FK_KEY
,      HOLD_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
,      SOB_FK_KEY
,      GEOGRAPHY_FK_KEY
,      INV_CURRENCY_FK_KEY
,      PAYMENT_TERM_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
,      SUPPLIER_SITE_ID
,      INV_AMT_T
,      INV_AMT_G
,      INV_AMT_B
,      HOLD_DATA_PK_KEY
,      HOLD_COUNT
,      HELD_BY
,      CCID
,      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
,      RELEASE_REASON
,      RELEASE_LOOKUP_CODE
,      INV_TYPE
,      INV_SOURCE
,      INV_NUM
,      INSTANCE
,      HOLD_REASON
,      HOLD_LOOKUP_CODE
,      HOLD_DATA_PK
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      HOLD_DATE
,      HOLD_RELEASE_COUNT
,      HOLD_RELEASE_DAYS
FROM APPS.POA_FII_AP_HOLD_DATA_F_V;

Dependencies

[top of page]

APPS.POA_FII_AP_HOLD_DATA_F_V references the following:

SchemaAPPS
SynonymFII_AP_HOLD_DATA_F

APPS.POA_FII_AP_HOLD_DATA_F_V is not referenced by any database object