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

MATERIALIZED VIEW: APPS.POA_REQ_002_MV

Object Details
Object Name: POA_REQ_002_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: POA_REQ_002_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:

BIS_BUCKET
BIS_BUCKET_CUSTOMIZATIONS
FII_TIME_DAY
POA_DBI_REQ_F

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
GRP_ID NUMBER

Grouping ID Column
TIME_ID NUMBER

Nested Grouping ID Column for Time
PERIOD_TYPE_ID NUMBER

Period Type Identifier
AGGREGATION_LEVEL NUMBER

Grouping ID Column
CATEGORY_ID NUMBER

Category on the PO Line Identifier
PO_ITEM_ID NUMBER

Purchased Item Identifier
SUPPLIER_ID NUMBER

Supplier Identifier
BUYER_ID NUMBER

Buyer Identifier
SHIP_TO_ORG_ID NUMBER

Ship To Organization Identifier
REQUESTER_ID NUMBER

Requester Identifier
ORG_ID NUMBER

Operating Unit Identifier
BASE_UOM VARCHAR2 (25)
Base UOM
ENT_YEAR_ID NUMBER

Enterprise Year Identifier
ENT_QTR_ID NUMBER

Enterprise Quarter Identifier
ENT_PERIOD_ID NUMBER

Enterprise Period Identifier
WEEK_ID NUMBER

FII Week Identifier
DAY_ID NUMBER

FII Day Identifier
FULFILLED_AMT_B NUMBER

Fulfilled (Fully Received/Invoiced depending on match option) Amount in Functional Currency
FULFILLED_AMT_G NUMBER

Fulfilled (Fully Received/Invoiced depending on match option) Amount in Global Currency
FULFILLED_AMT_SG NUMBER

Fulfilled (Fully Received/Invoiced depending on match option) Amount in Secondary Global Currency
FULFILLED_MAN_AMT_B NUMBER

Amount that has been fulfilled Manually in Functional Currency
FULFILLED_MAN_AMT_G NUMBER

Amount that has been fulfilled Manually in Global Currency
FULFILLED_MAN_AMT_SG NUMBER

Amount that has been fulfilled Manually in Secondary Global Currency
FULFILLED_QTY NUMBER

Fulfilled Quantity
DAYS_TO_FULFILL NUMBER

Number of Days for a Requisition to become Fulfilled
FULFILLED_CNT_B NUMBER

Count of Fulfilled Requisitions
FULFILLED_CNT_G NUMBER

Count of Fulfilled Requisitions
FULFILLED_CNT_SG NUMBER

Count of Fulfilled Requisitions
FULFILLED_MAN_CNT_B NUMBER

Count of Requisitions that have been fulfilled Manually
FULFILLED_MAN_CNT_G NUMBER

Count of Requisitions that have been fulfilled Manually
FULFILLED_MAN_CNT_SG NUMBER

Count of Requisitions that have been fulfilled Manually
FULFILLED_QTY_CNT NUMBER

Count of Quantity of Fulfilled Requisitions
DAYS_TO_FULFILL_CNT NUMBER

Count of Days taken to Fulfill a Requisition
FULFILLED_PED_CNT NUMBER

Count of Fulfilled Requisitions that are Past Expected Date
FULFILLED_AMT_B_AGE_B1 NUMBER

Fulfilled Amount in Functional Currency in Bucket Range 1
FULFILLED_AMT_B_AGE_B2 NUMBER

Fulfilled Amount in Functional Currency in Bucket Range 2
FULFILLED_AMT_B_AGE_B3 NUMBER

Fulfilled Amount in Functional Currency in Bucket Range 3
FULFILLED_AMT_B_AGE_B4 NUMBER

Fulfilled Amount in Functional Currency in Bucket Range 4
FULFILLED_AMT_B_AGE_B5 NUMBER

Fulfilled Amount in Functional Currency in Bucket Range 5
FULFILLED_AMT_B_AGE_B6 NUMBER

Fulfilled Amount in Functional Currency in Bucket Range 6
FULFILLED_AMT_B_AGE_B7 NUMBER

Fulfilled Amount in Functional Currency in Bucket Range 7
FULFILLED_AMT_B_AGE_B8 NUMBER

Fulfilled Amount in Functional Currency in Bucket Range 8
FULFILLED_AMT_B_AGE_B9 NUMBER

Fulfilled Amount in Functional Currency in Bucket Range 9
FULFILLED_AMT_B_AGE_B10 NUMBER

Fulfilled Amount in Functional Currency in Bucket Range 10
FULFILLED_AMT_G_AGE_B1 NUMBER

Fulfilled Amount in Global Currency in Bucket Range 1
FULFILLED_AMT_G_AGE_B2 NUMBER

Fulfilled Amount in Global Currency in Bucket Range 2
FULFILLED_AMT_G_AGE_B3 NUMBER

Fulfilled Amount in Global Currency in Bucket Range 3
FULFILLED_AMT_G_AGE_B4 NUMBER

Fulfilled Amount in Global Currency in Bucket Range 4
FULFILLED_AMT_G_AGE_B5 NUMBER

Fulfilled Amount in Global Currency in Bucket Range 5
FULFILLED_AMT_G_AGE_B6 NUMBER

Fulfilled Amount in Global Currency in Bucket Range 6
FULFILLED_AMT_G_AGE_B7 NUMBER

Fulfilled Amount in Global Currency in Bucket Range 7
FULFILLED_AMT_G_AGE_B8 NUMBER

Fulfilled Amount in Global Currency in Bucket Range 8
FULFILLED_AMT_G_AGE_B9 NUMBER

Fulfilled Amount in Global Currency in Bucket Range 9
FULFILLED_AMT_G_AGE_B10 NUMBER

Fulfilled Amount in Global Currency in Bucket Range 10
FULFILLED_AMT_SG_AGE_B1 NUMBER

Fulfilled Amount in Secondary Global Currency in Bucket Range 1
FULFILLED_AMT_SG_AGE_B2 NUMBER

Fulfilled Amount in Secondary Global Currency in Bucket Range 2
FULFILLED_AMT_SG_AGE_B3 NUMBER

Fulfilled Amount in Secondary Global Currency in Bucket Range 3
FULFILLED_AMT_SG_AGE_B4 NUMBER

Fulfilled Amount in Secondary Global Currency in Bucket Range 4
FULFILLED_AMT_SG_AGE_B5 NUMBER

Fulfilled Amount in Secondary Global Currency in Bucket Range 5
FULFILLED_AMT_SG_AGE_B6 NUMBER

Fulfilled Amount in Secondary Global Currency in Bucket Range 6
FULFILLED_AMT_SG_AGE_B7 NUMBER

Fulfilled Amount in Secondary Global Currency in Bucket Range 7
FULFILLED_AMT_SG_AGE_B8 NUMBER

Fulfilled Amount in Secondary Global Currency in Bucket Range 8
FULFILLED_AMT_SG_AGE_B9 NUMBER

Fulfilled Amount in Secondary Global Currency in Bucket Range 9
FULFILLED_AMT_SG_AGE_B10 NUMBER

Fulfilled Amount in Secondary Global Currency in Bucket Range 10
FULFILLED_CNT_B_AGE_B1 NUMBER

Number of Fulfilled Requisitions in Bucket Range 1
FULFILLED_CNT_B_AGE_B2 NUMBER

Number of Fulfilled Requisitions in Bucket Range 2
FULFILLED_CNT_B_AGE_B3 NUMBER

Number of Fulfilled Requisitions in Bucket Range 3
FULFILLED_CNT_B_AGE_B4 NUMBER

Number of Fulfilled Requisitions in Bucket Range 4
FULFILLED_CNT_B_AGE_B5 NUMBER

Number of Fulfilled Requisitions in Bucket Range 5
FULFILLED_CNT_B_AGE_B6 NUMBER

Number of Fulfilled Requisitions in Bucket Range 6
FULFILLED_CNT_B_AGE_B7 NUMBER

Number of Fulfilled Requisitions in Bucket Range 7
FULFILLED_CNT_B_AGE_B8 NUMBER

Number of Fulfilled Requisitions in Bucket Range 8
FULFILLED_CNT_B_AGE_B9 NUMBER

Number of Fulfilled Requisitions in Bucket Range 9
FULFILLED_CNT_B_AGE_B10 NUMBER

Number of Fulfilled Requisitions in Bucket Range 10
FULFILLED_CNT_G_AGE_B1 NUMBER

Number of Fulfilled Requisitions in Bucket Range 1
FULFILLED_CNT_G_AGE_B2 NUMBER

Number of Fulfilled Requisitions in Bucket Range 2
FULFILLED_CNT_G_AGE_B3 NUMBER

Number of Fulfilled Requisitions in Bucket Range 3
FULFILLED_CNT_G_AGE_B4 NUMBER

Number of Fulfilled Requisitions in Bucket Range 4
FULFILLED_CNT_G_AGE_B5 NUMBER

Number of Fulfilled Requisitions in Bucket Range 5
FULFILLED_CNT_G_AGE_B6 NUMBER

Number of Fulfilled Requisitions in Bucket Range 6
FULFILLED_CNT_G_AGE_B7 NUMBER

Number of Fulfilled Requisitions in Bucket Range 7
FULFILLED_CNT_G_AGE_B8 NUMBER

Number of Fulfilled Requisitions in Bucket Range 8
FULFILLED_CNT_G_AGE_B9 NUMBER

Number of Fulfilled Requisitions in Bucket Range 9
FULFILLED_CNT_G_AGE_B10 NUMBER

Number of Fulfilled Requisitions in Bucket Range 10
FULFILLED_CNT_SG_AGE_B1 NUMBER

Number of Fulfilled Requisitions in Bucket Range 1
FULFILLED_CNT_SG_AGE_B2 NUMBER

Number of Fulfilled Requisitions in Bucket Range 2
FULFILLED_CNT_SG_AGE_B3 NUMBER

Number of Fulfilled Requisitions in Bucket Range 3
FULFILLED_CNT_SG_AGE_B4 NUMBER

Number of Fulfilled Requisitions in Bucket Range 4
FULFILLED_CNT_SG_AGE_B5 NUMBER

Number of Fulfilled Requisitions in Bucket Range 5
FULFILLED_CNT_SG_AGE_B6 NUMBER

Number of Fulfilled Requisitions in Bucket Range 6
FULFILLED_CNT_SG_AGE_B7 NUMBER

Number of Fulfilled Requisitions in Bucket Range 7
FULFILLED_CNT_SG_AGE_B8 NUMBER

Number of Fulfilled Requisitions in Bucket Range 8
FULFILLED_CNT_SG_AGE_B9 NUMBER

Number of Fulfilled Requisitions in Bucket Range 9
FULFILLED_CNT_SG_AGE_B10 NUMBER

Number of Fulfilled Requisitions in Bucket Range 10
C_TOTAL NUMBER

Count column
Query Text

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


SELECT GRP_ID
,      TIME_ID
,      PERIOD_TYPE_ID
,      AGGREGATION_LEVEL
,      CATEGORY_ID
,      PO_ITEM_ID
,      SUPPLIER_ID
,      BUYER_ID
,      SHIP_TO_ORG_ID
,      REQUESTER_ID
,      ORG_ID
,      BASE_UOM
,      ENT_YEAR_ID
,      ENT_QTR_ID
,      ENT_PERIOD_ID
,      WEEK_ID
,      DAY_ID
,      FULFILLED_AMT_B
,      FULFILLED_AMT_G
,      FULFILLED_AMT_SG
,      FULFILLED_MAN_AMT_B
,      FULFILLED_MAN_AMT_G
,      FULFILLED_MAN_AMT_SG
,      FULFILLED_QTY
,      DAYS_TO_FULFILL
,      FULFILLED_CNT_B
,      FULFILLED_CNT_G
,      FULFILLED_CNT_SG
,      FULFILLED_MAN_CNT_B
,      FULFILLED_MAN_CNT_G
,      FULFILLED_MAN_CNT_SG
,      FULFILLED_QTY_CNT
,      DAYS_TO_FULFILL_CNT
,      FULFILLED_PED_CNT
,      FULFILLED_AMT_B_AGE_B1
,      FULFILLED_AMT_B_AGE_B2
,      FULFILLED_AMT_B_AGE_B3
,      FULFILLED_AMT_B_AGE_B4
,      FULFILLED_AMT_B_AGE_B5
,      FULFILLED_AMT_B_AGE_B6
,      FULFILLED_AMT_B_AGE_B7
,      FULFILLED_AMT_B_AGE_B8
,      FULFILLED_AMT_B_AGE_B9
,      FULFILLED_AMT_B_AGE_B10
,      FULFILLED_AMT_G_AGE_B1
,      FULFILLED_AMT_G_AGE_B2
,      FULFILLED_AMT_G_AGE_B3
,      FULFILLED_AMT_G_AGE_B4
,      FULFILLED_AMT_G_AGE_B5
,      FULFILLED_AMT_G_AGE_B6
,      FULFILLED_AMT_G_AGE_B7
,      FULFILLED_AMT_G_AGE_B8
,      FULFILLED_AMT_G_AGE_B9
,      FULFILLED_AMT_G_AGE_B10
,      FULFILLED_AMT_SG_AGE_B1
,      FULFILLED_AMT_SG_AGE_B2
,      FULFILLED_AMT_SG_AGE_B3
,      FULFILLED_AMT_SG_AGE_B4
,      FULFILLED_AMT_SG_AGE_B5
,      FULFILLED_AMT_SG_AGE_B6
,      FULFILLED_AMT_SG_AGE_B7
,      FULFILLED_AMT_SG_AGE_B8
,      FULFILLED_AMT_SG_AGE_B9
,      FULFILLED_AMT_SG_AGE_B10
,      FULFILLED_CNT_B_AGE_B1
,      FULFILLED_CNT_B_AGE_B2
,      FULFILLED_CNT_B_AGE_B3
,      FULFILLED_CNT_B_AGE_B4
,      FULFILLED_CNT_B_AGE_B5
,      FULFILLED_CNT_B_AGE_B6
,      FULFILLED_CNT_B_AGE_B7
,      FULFILLED_CNT_B_AGE_B8
,      FULFILLED_CNT_B_AGE_B9
,      FULFILLED_CNT_B_AGE_B10
,      FULFILLED_CNT_G_AGE_B1
,      FULFILLED_CNT_G_AGE_B2
,      FULFILLED_CNT_G_AGE_B3
,      FULFILLED_CNT_G_AGE_B4
,      FULFILLED_CNT_G_AGE_B5
,      FULFILLED_CNT_G_AGE_B6
,      FULFILLED_CNT_G_AGE_B7
,      FULFILLED_CNT_G_AGE_B8
,      FULFILLED_CNT_G_AGE_B9
,      FULFILLED_CNT_G_AGE_B10
,      FULFILLED_CNT_SG_AGE_B1
,      FULFILLED_CNT_SG_AGE_B2
,      FULFILLED_CNT_SG_AGE_B3
,      FULFILLED_CNT_SG_AGE_B4
,      FULFILLED_CNT_SG_AGE_B5
,      FULFILLED_CNT_SG_AGE_B6
,      FULFILLED_CNT_SG_AGE_B7
,      FULFILLED_CNT_SG_AGE_B8
,      FULFILLED_CNT_SG_AGE_B9
,      FULFILLED_CNT_SG_AGE_B10
,      C_TOTAL
FROM APPS.POA_REQ_002_MV;

Dependencies

[top of page]

APPS.POA_REQ_002_MV references the following:

SchemaAPPS
TablePOA_REQ_002_MV
SchemaBIS
TableBIS_BUCKET
TableBIS_BUCKET_CUSTOMIZATIONS
SchemaFII
TableFII_TIME_DAY
SchemaPOA
TablePOA_DBI_REQ_F

APPS.POA_REQ_002_MV is not referenced by any database object