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

MATERIALIZED VIEW: APPS.POA_PQC_BS_J2_MV

Object Details
Object Name: POA_PQC_BS_J2_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: POA_PQC_BS_J2_MV
Updatable: N
Rewrite Enabled: N
Rewrite Capability: GENERAL
Refresh Mode: DEMAND
Refresh Method: FAST
Build Mode: DEFERRED
Fast Refreshable: DIRLOAD_DML
MV Log Dependencies:

POA_BM_ITEM_O_MV
     POA_PQC_BS_J_MV
          FII_COM_CC_DIM_MAPS
          FII_TIME_DAY
          POA_DBI_POD_F
          PO_COMMODITY_CATEGORIES
POA_BM_ITEM_S_MV
     POA_PQC_BS_J_MV
          FII_COM_CC_DIM_MAPS
          FII_TIME_DAY
          POA_DBI_POD_F
          PO_COMMODITY_CATEGORIES
POA_PQC_BS_J_MV
     FII_COM_CC_DIM_MAPS
     FII_TIME_DAY
     POA_DBI_POD_F
     PO_COMMODITY_CATEGORIES

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
FRID ROWID (10)
FRID
PRID ROWID (10)
PRID
PSRID ROWID (10)
PSRID
ORG_ID NUMBER

Operating Unit Identifier
SHIP_TO_ORG_ID NUMBER

Ship to Organization Identifier
SUPPLIER_ID NUMBER

Supplier Identifier
SUPPLIER_SITE_ID NUMBER

Supplier Site Identifier
COMMODITY_ID NUMBER

Commodity Identifier
CATEGORY_ID NUMBER

Category on the PO Line Identifier
PO_ITEM_ID NUMBER
Yes Purchased Item Identifier
BASE_UOM VARCHAR2 (25)
Base UOM
BUYER_ID NUMBER
Yes Buyer Identifier
COMPANY_ID NUMBER (15)
Company identifier
COST_CENTER_ID NUMBER (15)
Cost-center Identifier
ENT_QTR_ID NUMBER

Enterprise Quarter Identifier
ENT_PERIOD_ID NUMBER

Enterprise Period Identifier
WEEK_ID NUMBER
Yes FII Week Identifier
DAY_ID NUMBER
Yes FII Day Identifier
ENT_YEAR_ID NUMBER

Enterprise Year Identifier
P_ENT_YEAR_ID NUMBER

prior enterprise year identifier
PURCHASE_AMT_G NUMBER

Purchased Amount in global currency
PURCHASE_AMT_SG NUMBER

Purchased Amount in secondary global currency
PURCHASE_AMT_B NUMBER

Purchased Amount in functional currency
QUANTITY NUMBER

Quantity in Base UOM
GLOBAL_CUR_CONV_RATE NUMBER

Global currency conversion rate
PIP_AMT_G NUMBER

Prior enterprise year total purchased amount of the same item,uom,and operating unit, in global currency
PIP_AMT_SG NUMBER

Prior enterprise year total purchased amount of the same item,uom,and operating unit, in global currency
PIP_AMT_B NUMBER

Prior enterprise year total purchased amount of the same item,uom,and operating unit, in functional currency
PIP_QUANTITY NUMBER

Prior enterprise year total quantity of the same item,uom,and operating unit, in base UOM
PISP_AMT_G NUMBER

Prior enterprise year total purchase amount of the same item,uom,and supplier, in global currency
PISP_AMT_SG NUMBER

Prior enterprise year total purchase amount of the same item,uom,and supplier, in global currency
PISP_QUANTITY NUMBER

Prior enterprise year total quantity of the same item,uom,and supplier, in base UOM
PO_HEADER_ID NUMBER
Yes PO header identifier
PO_LINE_ID NUMBER
Yes PO line identifier
PO_RELEASE_ID NUMBER

PO release identifier
APPROVED_DATE DATE

Earliest approval date
ORDER_TYPE VARCHAR2 (25)
Order Type
CONSIGNED_CODE NUMBER

Consigned Code
COMPLEX_WORK_FLAG VARCHAR2 (1)
Complex work flag
Query Text

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


SELECT FRID
,      PRID
,      PSRID
,      ORG_ID
,      SHIP_TO_ORG_ID
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      COMMODITY_ID
,      CATEGORY_ID
,      PO_ITEM_ID
,      BASE_UOM
,      BUYER_ID
,      COMPANY_ID
,      COST_CENTER_ID
,      ENT_QTR_ID
,      ENT_PERIOD_ID
,      WEEK_ID
,      DAY_ID
,      ENT_YEAR_ID
,      P_ENT_YEAR_ID
,      PURCHASE_AMT_G
,      PURCHASE_AMT_SG
,      PURCHASE_AMT_B
,      QUANTITY
,      GLOBAL_CUR_CONV_RATE
,      PIP_AMT_G
,      PIP_AMT_SG
,      PIP_AMT_B
,      PIP_QUANTITY
,      PISP_AMT_G
,      PISP_AMT_SG
,      PISP_QUANTITY
,      PO_HEADER_ID
,      PO_LINE_ID
,      PO_RELEASE_ID
,      APPROVED_DATE
,      ORDER_TYPE
,      CONSIGNED_CODE
,      COMPLEX_WORK_FLAG
FROM APPS.POA_PQC_BS_J2_MV;

Dependencies

[top of page]

APPS.POA_PQC_BS_J2_MV references the following:

SchemaAPPS
TablePOA_BM_ITEM_O_MV
Materialized ViewPOA_BM_ITEM_O_MV
Materialized ViewPOA_BM_ITEM_S_MV
TablePOA_BM_ITEM_S_MV
TablePOA_PQC_BS_J2_MV
TablePOA_PQC_BS_J_MV
Materialized ViewPOA_PQC_BS_J_MV
APPS.POA_PQC_BS_J2_MV is referenced by following:

SchemaAPPS
Materialized ViewPOA_PQC_001_MV
Materialized ViewPOA_PQC_BS_MV