eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: FII.FII_AP_INV_B

Object Details

Object Name:	FII_AP_INV_B
Object Type:	TABLE
Owner:	FII
FND Design Data:	FII.FII_AP_INV_B
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.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FII_AP_INV_B_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	EMPLOYEE_ID ACCOUNT_DATE
FII_AP_INV_B_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	COST_CENTER_ID COMPANY_ID ACCOUNT_DATE
FII_AP_INV_B_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	INVOICE_ID
FII_AP_INV_B_N4	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	SUPPLIER_SITE_ID SUPPLIER_ID

Columns

Name	Datatype	Length	Comments
SET_OF_BOOKS_ID	NUMBER	(15)	No longer used
ACCOUNT_DATE	DATE		Accounting Date of invoice distribution
ACCOUNT_DATE_ID	NUMBER		Accounting Date of invoice distribution converted to Julian date format
INV_CURRENCY_CODE	VARCHAR2	(15)	Accounting Currency Code
AMOUNT_T	NUMBER		Amount in transaction currency
INVOICE_ID	NUMBER	(15)	Invoice ID for the Inv. Distribution
AMOUNT_B	NUMBER		Amount in base currency
PO_MATCHED_FLAG	VARCHAR2	(1)	Flag if invoice is PO matched or not
SOURCE	VARCHAR2	(25)	Source of Invoice
INV_DIST_CREATED_BY	NUMBER	(15)	Who created the Inv. Distribution
SUPPLIER_SITE_ID	NUMBER		Supplier Site identifier
INV_DIST_CREATION_DATE	DATE		Creation date of invoice distribution
SUPPLIER_ID	NUMBER	(15)	Supplier Identifier
DIST_COUNT	NUMBER		Count of Unique Inv. Distributions
INVOICE_TYPE	VARCHAR2	(25)	Type of invoice
POSTED_FLAG	VARCHAR2	(1)	Flag indicating if invoice distribution is posted
COST_CENTER_ORG_ID	NUMBER	(15)	No longer used - Cost center org id
CHART_OF_ACCOUNTS_ID	NUMBER	(15)	Chart of Accounts ID
PRIM_AMOUNT_G	NUMBER		Amount in primary global currency
SEC_AMOUNT_G	NUMBER		Amount in secondary global currency
UPDATE_SEQUENCE	NUMBER		Sequence to identify deleted invoices
APPROVED_FLAG	VARCHAR2	(1)	Flag indicating if invoice distribution is approved
ORG_ID	NUMBER	(15)	Organization identifier
LAST_UPDATE_DATE	DATE		Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
TASK_ID	NUMBER	(15)	Task Identifier
PROJECT_ID	NUMBER	(15)	Project Identifier
QUANTITY_INVOICED	NUMBER		Quantity Invoiced
PO_DISTRIBUTION_ID	NUMBER	(15)	Purchase Order Distribution Identifier
DIST_CCID	NUMBER	(15)	General Ledger Code Combination Identifier
INVOICE_DISTRIBUTION_ID	NUMBER	(15)	Invoice Distribution Identifier
EMPLOYEE_ID	NUMBER	(15)	Employee Identifier
INVOICE_NUM	VARCHAR2	(50)	Invoice Number
FIN_CATEGORY_ID	NUMBER	(15)	Financial Category Identifier
COMPANY_ID	NUMBER	(15)	Company Identifier
COST_CENTER_ID	NUMBER	(15)	Cost Center Identifier
LINE_TYPE_LOOKUP_CODE	VARCHAR2	(25)	Line type lookup code
DISCRETIONARY_EXPENSE_FLAG	VARCHAR2	(1)	Discretionary Expense Flag
USER_DIM1_ID	NUMBER	(15)	User Defined Dimension 1 Identifier
USER_DIM2_ID	NUMBER	(15)	User Defined Dimension 2 Identifier
TRANS_CURRENCY_CODE	VARCHAR2	(15)	Currency code of invoice
INVOICE_DATE	DATE		Invoice date
DISTRIBUTION_LINE_NUMBER	NUMBER	(15)	Distribution line number
EXP_REPORT_HEADER_ID	NUMBER		Expense report header identifier
PO_HEADER_ID	NUMBER		Document header unique identifier
PO_RELEASE_ID	NUMBER		Release unique identifier
PO_NUM	VARCHAR2	(20)	Document number
LEDGER_ID	NUMBER	(15)	Ledger Identifier
AE_HEADER_ID	NUMBER	(15)	Subledger journal entry identifier
REF_AE_HEADER_ID	NUMBER	(15)	Reversed subledger journal entry header identifier
TEMP_LINE_NUM	NUMBER	(15)	Temporary line number generated by accounting engine in SLA temporary journal entries table
GL_SL_LINK_ID	NUMBER	(15)	Audit trail to General Ledger
GL_SL_LINK_TABLE	VARCHAR2	(30)	Subledger link table name used to link GL journal lines with subledger journal entry lines
INVENTORY_ITEM_ID	NUMBER	(15)	Inventory item identifier
ITEM_DESCRIPTION	VARCHAR2	(240)	Item description
PURCHASING_CATEGORY_ID	NUMBER	(15)	Purchasing category identifier

Query Text

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


SELECT SET_OF_BOOKS_ID
,      ACCOUNT_DATE
,      ACCOUNT_DATE_ID
,      INV_CURRENCY_CODE
,      AMOUNT_T
,      INVOICE_ID
,      AMOUNT_B
,      PO_MATCHED_FLAG
,      SOURCE
,      INV_DIST_CREATED_BY
,      SUPPLIER_SITE_ID
,      INV_DIST_CREATION_DATE
,      SUPPLIER_ID
,      DIST_COUNT
,      INVOICE_TYPE
,      POSTED_FLAG
,      COST_CENTER_ORG_ID
,      CHART_OF_ACCOUNTS_ID
,      PRIM_AMOUNT_G
,      SEC_AMOUNT_G
,      UPDATE_SEQUENCE
,      APPROVED_FLAG
,      ORG_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      TASK_ID
,      PROJECT_ID
,      QUANTITY_INVOICED
,      PO_DISTRIBUTION_ID
,      DIST_CCID
,      INVOICE_DISTRIBUTION_ID
,      EMPLOYEE_ID
,      INVOICE_NUM
,      FIN_CATEGORY_ID
,      COMPANY_ID
,      COST_CENTER_ID
,      LINE_TYPE_LOOKUP_CODE
,      DISCRETIONARY_EXPENSE_FLAG
,      USER_DIM1_ID
,      USER_DIM2_ID
,      TRANS_CURRENCY_CODE
,      INVOICE_DATE
,      DISTRIBUTION_LINE_NUMBER
,      EXP_REPORT_HEADER_ID
,      PO_HEADER_ID
,      PO_RELEASE_ID
,      PO_NUM
,      LEDGER_ID
,      AE_HEADER_ID
,      REF_AE_HEADER_ID
,      TEMP_LINE_NUM
,      GL_SL_LINK_ID
,      GL_SL_LINK_TABLE
,      INVENTORY_ITEM_ID
,      ITEM_DESCRIPTION
,      PURCHASING_CATEGORY_ID
FROM FII.FII_AP_INV_B;

Dependencies

[top of page]

FII.FII_AP_INV_B does not reference any database object

FII.FII_AP_INV_B is referenced by following:

APPS: FII_AP_INV_B; POA_API_BS_J_MV; POA_IDL_BS_J_MV; POA_MID_BS_J_MV