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

TABLE: APPS.FII_AP_HLIA_IB_MV

Object Details
Object Name: FII_AP_HLIA_IB_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.FII_AP_HLIA_IB_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ORG_ID NUMBER (15)
Operating Unit Identifier
SUPPLIER_ID NUMBER (15)
Supplier Identifier
INVOICE_ID NUMBER (15)
Invoice Identifier
TIME_ID NUMBER

Time identifier
PERIOD_TYPE_ID NUMBER

Period Type Identifier
HOLD_DATE DATE

Date on which Invoice is placed on hold
RELEASE_DATE DATE

Date on which Invoice is released
ACTION VARCHAR2 (30)
Action being performed on the invoice: hold, release, due, due bucket, past bucket, discount and withholding
DUE_DATE DATE

Due Date for the Invoice
ON_HOLD_AMOUNT_B NUMBER

Total invoices amounts on hold in base currency
ON_HOLD_AMOUNT_PRIM_G NUMBER

Total invoices amounts on hold in primary currency
ON_HOLD_AMOUNT_SEC_G NUMBER

Total invoices amounts on hold in secondary currency
ON_HOLD_PAYMENT_AMOUNT_B NUMBER

Total payments for invoices on hold in base currency
ON_HOLD_PAYMENT_AMOUNT_PRIM_G NUMBER

Total payments for invoices on hold in primary currency
ON_HOLD_PAYMENT_AMOUNT_SEC_G NUMBER

Total payments for invoices on hold in secondary currency
ON_HOLD_PAST_DUE_AMOUNT_B NUMBER

Total past due amount for invoices on hold in base currency
ON_HOLD_PAST_DUE_AMOUNT_PRIM_G NUMBER

Total past due amount for invoices on hold in primary currency
ON_HOLD_PAST_DUE_AMOUNT_SEC_G NUMBER

Total past due amount for invoices on hold in secondary currency
ON_HOLD_DIS_OFFERED_B NUMBER

Total discount offered for invoices on hold in base currency
ON_HOLD_DIS_OFFERED_PRIM_G NUMBER

Total discount offered for invoices on hold in primary currency
ON_HOLD_DIS_OFFERED_SEC_G NUMBER

Total discount offered for invoices on hold in secondary currency
ON_HOLD_DIS_AVAILABLE_B NUMBER

Total discount available for invoices on hold in base currency
ON_HOLD_DIS_AVAILABLE_PRIM_G NUMBER

Total discount available for invoices on hold in primary currency
ON_HOLD_DIS_AVAILABLE_SEC_G NUMBER

Total discount available for invoices on hold in secondary currency
ON_HOLD_DIS_TAKEN_B NUMBER

Total discount taken for invoices on hold in base currency
ON_HOLD_DIS_TAKEN_PRIM_G NUMBER

Total discount taken for invoices on hold in primary currency
ON_HOLD_DIS_TAKEN_SEC_G NUMBER

Total discount taken for invoices on hold in secondary currency
ON_HOLD_DIS_LOST_B NUMBER

Total discount lost for invoices on hold in base currency
ON_HOLD_DIS_LOST_PRIM_G NUMBER

Total discount lost for invoices on hold in primary currency
ON_HOLD_DIS_LOST_SEC_G NUMBER

Total discount lost for invoices on hold in secondary currency
NO_OF_HOLDS NUMBER

Number of Holds placed on the Invoices
Query Text

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


SELECT ORG_ID
,      SUPPLIER_ID
,      INVOICE_ID
,      TIME_ID
,      PERIOD_TYPE_ID
,      HOLD_DATE
,      RELEASE_DATE
,      ACTION
,      DUE_DATE
,      ON_HOLD_AMOUNT_B
,      ON_HOLD_AMOUNT_PRIM_G
,      ON_HOLD_AMOUNT_SEC_G
,      ON_HOLD_PAYMENT_AMOUNT_B
,      ON_HOLD_PAYMENT_AMOUNT_PRIM_G
,      ON_HOLD_PAYMENT_AMOUNT_SEC_G
,      ON_HOLD_PAST_DUE_AMOUNT_B
,      ON_HOLD_PAST_DUE_AMOUNT_PRIM_G
,      ON_HOLD_PAST_DUE_AMOUNT_SEC_G
,      ON_HOLD_DIS_OFFERED_B
,      ON_HOLD_DIS_OFFERED_PRIM_G
,      ON_HOLD_DIS_OFFERED_SEC_G
,      ON_HOLD_DIS_AVAILABLE_B
,      ON_HOLD_DIS_AVAILABLE_PRIM_G
,      ON_HOLD_DIS_AVAILABLE_SEC_G
,      ON_HOLD_DIS_TAKEN_B
,      ON_HOLD_DIS_TAKEN_PRIM_G
,      ON_HOLD_DIS_TAKEN_SEC_G
,      ON_HOLD_DIS_LOST_B
,      ON_HOLD_DIS_LOST_PRIM_G
,      ON_HOLD_DIS_LOST_SEC_G
,      NO_OF_HOLDS
FROM APPS.FII_AP_HLIA_IB_MV;

Dependencies

[top of page]

APPS.FII_AP_HLIA_IB_MV does not reference any database object

APPS.FII_AP_HLIA_IB_MV is referenced by following:

SchemaAPPS
Materialized ViewFII_AP_HLIA_IB_MV
Materialized ViewFII_AP_HLIA_I_MV