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

TABLE: FII.FII_AP_OP_INDICATOR_SUMMARY

Object Details
Object Name: FII_AP_OP_INDICATOR_SUMMARY
Object Type: TABLE
Owner: FII
FND Design Data: TableFII.FII_AP_OP_INDICATOR_SUMMARY
Subobject Name:
Status: VALID


This summary table holds AP Invoices and AP Payment information. It is used to support Procure to Pay portlets.


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
OPERATING_UNIT_PK_KEY NUMBER
Yes Foreign key to the operating unit level of Organization dimension
OPERATING_UNIT_NAME VARCHAR2 (150)
Name of the operating unt
TRADING_PARTNER_PK_KEY NUMBER
Yes Foreign key to the trading partner level of Trading Partner dimension
TRADING_PARTNER_NAME VARCHAR2 (120)
Name of the trading partner
INV_LINES_COUNT NUMBER

Total number of invoice lines created for QTD
INV_COUNT NUMBER

The number of invoices column is number of invoices that were invoiced in the current quarter
INV_PAYMENT_COUNT NUMBER

Total number of invoice payments created for QTD
INV_AMOUNT NUMBER

Total amount of invoices created for QTD in functional currency
INV_PAYMENT_AMOUNT NUMBER

Total amount of invoice payments created for QTD in functional currency
Query Text

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


SELECT OPERATING_UNIT_PK_KEY
,      OPERATING_UNIT_NAME
,      TRADING_PARTNER_PK_KEY
,      TRADING_PARTNER_NAME
,      INV_LINES_COUNT
,      INV_COUNT
,      INV_PAYMENT_COUNT
,      INV_AMOUNT
,      INV_PAYMENT_AMOUNT
FROM FII.FII_AP_OP_INDICATOR_SUMMARY;

Dependencies

[top of page]

FII.FII_AP_OP_INDICATOR_SUMMARY does not reference any database object

FII.FII_AP_OP_INDICATOR_SUMMARY is referenced by following:

SchemaAPPS
SynonymFII_AP_OP_INDICATOR_SUMMARY