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

MATERIALIZED VIEW: APPS.POA_REQ_000_MV

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

BIS_BUCKET_CUSTOMIZATIONS

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
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
NUM_DAYS_UNPROCESSED NUMBER

Number of Days since the Requisition Line is Unprocessed
NUM_DAYS_UNFULFILLED NUMBER

Number of Days since the Requisition Line is Unfulfilled
PEN_SRC_AMT_G NUMBER

Requisition Amount Pending in Sourcing Phase in Global Currency
PEN_SRC_AMT_B NUMBER

Requisition Amount Pending in Sourcing Phase in functional Currency
PEN_SRC_AMT_SG NUMBER

Requisition Amount Pending in Sourcing Phase in Secondary Global Currency
PEN_BUYER_WK_AMT_G NUMBER

Requisition Amount Pending in Buyers Workbench Phase in global Currency
PEN_BUYER_WK_AMT_B NUMBER

Requisition Amount Pending in Buyers Workbench Phase in function Currency
PEN_BUYER_WK_AMT_SG NUMBER

Requisition Amount Pending in Buyers Workbench Phase in Secondary Global Currency
PEN_PO_SUBMIT_AMT_G NUMBER

Requisition Amount Pending Submission for PO Approval in Global Currency
PEN_PO_SUBMIT_AMT_B NUMBER

Requisition Amount Pending Submission for PO Approval in functional Currency
PEN_PO_SUBMIT_AMT_SG NUMBER

Requisition Amount Pending Submission for PO Approval in Secondary Global Currency
PEN_PO_APPR_AMT_G NUMBER

Requisition Amount Pending PO Approval in Global Currency
PEN_PO_APPR_AMT_B NUMBER

Requisition Amount Pending PO Approval in functional Currency
PEN_PO_APPR_AMT_SG NUMBER

Requisition Amount Pending PO Approval in Secondary Global Currency
UNPROCESSED_AMT_G NUMBER

Unprocessed Requisition Amount in Global Currency
UNPROCESSED_AMT_B NUMBER

Unprocessed Requisition Amount in functional Currency
UNPROCESSED_AMT_SG NUMBER

Unprocessed Requisition Amount in Secondary Global Currency
PEN_FULFILL_AMT_G NUMBER

Requisition Amount Pending PO Fulfillment in Global Currency
PEN_FULFILL_AMT_B NUMBER

Requisition Amount Pending PO Fulfillment in functional Currency
PEN_FULFILL_AMT_SG NUMBER

Requisition Amount Pending PO Fulfillement in Secondary Global Currency
UNFULFILLED_AMT_G NUMBER

Unfulfilled Requisition Amount in Global Currency
UNFULFILLED_AMT_B NUMBER

Unfulfilled Requisition Amount in functional Currency
UNFULFILLED_AMT_SG NUMBER

Unfulfilled Requisition Amount in Secondary Global Currency
PEN_SRC_CNT NUMBER

Count of Requisition Lines in Pending Sourcing Phase
PEN_BUYER_WK_CNT NUMBER

Count of Requisition Lines in Pending Buyers Workbench Phase
PEN_PO_SUBMIT_CNT NUMBER

Count of Requisition Lines in Pending PO Submission for Approval Phase
PEN_PO_APPR_CNT NUMBER

Count of Requisition Lines in Pending PO Approval Phase
UNPROCESSED_CNT NUMBER

Count of Unprocessed Requisition Lines
PEN_FULFILL_CNT NUMBER

Count of Pending Fulfillmemt Requisition Lines
UNFULFILLED_CNT NUMBER

Count of Unfulfilled Requisition Lines
UNPROCESSED_PED_CNT NUMBER

Count of Unprocessed Requisition Lines Past Expected Date
UNPROCESSED_EMER_CNT NUMBER

Count of Unprocessed Requisition Lines tagged as Emergency
UNPROCESSED_URG_CNT NUMBER

Count of Unprocessed Requisition Lines tagged as Urgent
UNFULFILLED_PED_CNT NUMBER

Count of Unfulfilled Requisition Lines Past Expected Date
UNPROCESSED_QTY NUMBER

Quantity in Unprocessed Phase
UNFULFILLED_QTY NUMBER

Quantity in Unfulfilled Phase
UNFUL_PO_REVISIONS NUMBER

Number of PO Revisions for an Unfulfilled Requisition
UNPROCESSED_AMT_G_AGE_B1 NUMBER

Unprocessed Amount in Global Currency in Bucket Range 1
UNPROCESSED_AMT_G_AGE_B2 NUMBER

Unprocessed Amount in Global Currency in Bucket Range 2
UNPROCESSED_AMT_G_AGE_B3 NUMBER

Unprocessed Amount in Global Currency in Bucket Range 3
UNPROCESSED_AMT_G_AGE_B4 NUMBER

Unprocessed Amount in Global Currency in Bucket Range 4
UNPROCESSED_AMT_G_AGE_B5 NUMBER

Unprocessed Amount in Global Currency in Bucket Range 5
UNPROCESSED_AMT_G_AGE_B6 NUMBER

Unprocessed Amount in Global Currency in Bucket Range 6
UNPROCESSED_AMT_G_AGE_B7 NUMBER

Unprocessed Amount in Global Currency in Bucket Range 7
UNPROCESSED_AMT_G_AGE_B8 NUMBER

Unprocessed Amount in Global Currency in Bucket Range 8
UNPROCESSED_AMT_G_AGE_B9 NUMBER

Unprocessed Amount in Global Currency in Bucket Range 9
UNPROCESSED_AMT_G_AGE_B10 NUMBER

Unprocessed Amount in Global Currency in Bucket Range 10
UNPROCESSED_AMT_B_AGE_B1 NUMBER

Unprocessed Amount in Functional Currency in Bucket Range 1
UNPROCESSED_AMT_B_AGE_B2 NUMBER

Unprocessed Amount in Functional Currency in Bucket Range 2
UNPROCESSED_AMT_B_AGE_B3 NUMBER

Unprocessed Amount in Functional Currency in Bucket Range 3
UNPROCESSED_AMT_B_AGE_B4 NUMBER

Unprocessed Amount in Functional Currency in Bucket Range 4
UNPROCESSED_AMT_B_AGE_B5 NUMBER

Unprocessed Amount in Functional Currency in Bucket Range 5
UNPROCESSED_AMT_B_AGE_B6 NUMBER

Unprocessed Amount in Functional Currency in Bucket Range 6
UNPROCESSED_AMT_B_AGE_B7 NUMBER

Unprocessed Amount in Functional Currency in Bucket Range 7
UNPROCESSED_AMT_B_AGE_B8 NUMBER

Unprocessed Amount in Functional Currency in Bucket Range 8
UNPROCESSED_AMT_B_AGE_B9 NUMBER

Unprocessed Amount in Functional Currency in Bucket Range 9
UNPROCESSED_AMT_B_AGE_B10 NUMBER

Unprocessed Amount in Functional Currency in Bucket Range 10
UNPROCESSED_AMT_SG_AGE_B1 NUMBER

Unprocessed Amount in Secondary Global Currency in Bucket Range 1
UNPROCESSED_AMT_SG_AGE_B2 NUMBER

Unprocessed Amount in Secondary Global Currency in Bucket Range 2
UNPROCESSED_AMT_SG_AGE_B3 NUMBER

Unprocessed Amount in Secondary Global Currency in Bucket Range 3
UNPROCESSED_AMT_SG_AGE_B4 NUMBER

Unprocessed Amount in Secondary Global Currency in Bucket Range 4
UNPROCESSED_AMT_SG_AGE_B5 NUMBER

Unprocessed Amount in Secondary Global Currency in Bucket Range 5
UNPROCESSED_AMT_SG_AGE_B6 NUMBER

Unprocessed Amount in Secondary Global Currency in Bucket Range 6
UNPROCESSED_AMT_SG_AGE_B7 NUMBER

Unprocessed Amount in Secondary Global Currency in Bucket Range 7
UNPROCESSED_AMT_SG_AGE_B8 NUMBER

Unprocessed Amount in Secondary Global Currency in Bucket Range 8
UNPROCESSED_AMT_SG_AGE_B9 NUMBER

Unprocessed Amount in Secondary Global Currency in Bucket Range 9
UNPROCESSED_AMT_SG_AGE_B10 NUMBER

Unprocessed Amount in Secondary Global Currency in Bucket Range 10
UNPROCESSED_CNT_AGE_B1 NUMBER

Number of Unprocessed Requisition Lines in Bucket Range 1
UNPROCESSED_CNT_AGE_B2 NUMBER

Number of Unprocessed Requisition Lines in Bucket Range 2
UNPROCESSED_CNT_AGE_B3 NUMBER

Number of Unprocessed Requisition Lines in Bucket Range 3
UNPROCESSED_CNT_AGE_B4 NUMBER

Number of Unprocessed Requisition Lines in Bucket Range 4
UNPROCESSED_CNT_AGE_B5 NUMBER

Number of Unprocessed Requisition Lines in Bucket Range 5
UNPROCESSED_CNT_AGE_B6 NUMBER

Number of Unprocessed Requisition Lines in Bucket Range 6
UNPROCESSED_CNT_AGE_B7 NUMBER

Number of Unprocessed Requisition Lines in Bucket Range 7
UNPROCESSED_CNT_AGE_B8 NUMBER

Number of Unprocessed Requisition Lines in Bucket Range 8
UNPROCESSED_CNT_AGE_B9 NUMBER

Number of Unprocessed Requisition Lines in Bucket Range 9
UNPROCESSED_CNT_AGE_B10 NUMBER

Number of Unprocessed Requisition Lines in Bucket Range 10
UNFULFILLED_AMT_G_AGE_B1 NUMBER

Unfulfilled Amount in Global Currency in Bucket Range 1
UNFULFILLED_AMT_G_AGE_B2 NUMBER

Unfulfilled Amount in Global Currency in Bucket Range 2
UNFULFILLED_AMT_G_AGE_B3 NUMBER

Unfulfilled Amount in Global Currency in Bucket Range 3
UNFULFILLED_AMT_G_AGE_B4 NUMBER

Unfulfilled Amount in Global Currency in Bucket Range 4
UNFULFILLED_AMT_G_AGE_B5 NUMBER

Unfulfilled Amount in Global Currency in Bucket Range 5
UNFULFILLED_AMT_G_AGE_B6 NUMBER

Unfulfilled Amount in Global Currency in Bucket Range 6
UNFULFILLED_AMT_G_AGE_B7 NUMBER

Unfulfilled Amount in Global Currency in Bucket Range 7
UNFULFILLED_AMT_G_AGE_B8 NUMBER

Unfulfilled Amount in Global Currency in Bucket Range 8
UNFULFILLED_AMT_G_AGE_B9 NUMBER

Unfulfilled Amount in Global Currency in Bucket Range 9
UNFULFILLED_AMT_G_AGE_B10 NUMBER

Unfulfilled Amount in Global Currency in Bucket Range 10
UNFULFILLED_AMT_B_AGE_B1 NUMBER

Unfulfilled Amount in Functional Currency in Bucket Range 1
UNFULFILLED_AMT_B_AGE_B2 NUMBER

Unfulfilled Amount in Functional Currency in Bucket Range 2
UNFULFILLED_AMT_B_AGE_B3 NUMBER

Unfulfilled Amount in Functional Currency in Bucket Range 3
UNFULFILLED_AMT_B_AGE_B4 NUMBER

Unfulfilled Amount in Functional Currency in Bucket Range 4
UNFULFILLED_AMT_B_AGE_B5 NUMBER

Unfulfilled Amount in Functional Currency in Bucket Range 5
UNFULFILLED_AMT_B_AGE_B6 NUMBER

Unfulfilled Amount in Functional Currency in Bucket Range 6
UNFULFILLED_AMT_B_AGE_B7 NUMBER

Unfulfilled Amount in Functional Currency in Bucket Range 7
UNFULFILLED_AMT_B_AGE_B8 NUMBER

Unfulfilled Amount in Functional Currency in Bucket Range 8
UNFULFILLED_AMT_B_AGE_B9 NUMBER

Unfulfilled Amount in Functional Currency in Bucket Range 9
UNFULFILLED_AMT_B_AGE_B10 NUMBER

Unfulfilled Amount in Functional Currency in Bucket Range 10
UNFULFILLED_AMT_SG_AGE_B1 NUMBER

Unfulfilled Amount in Secondary Global Currency in Bucket Range 1
UNFULFILLED_AMT_SG_AGE_B2 NUMBER

Unfulfilled Amount in Secondary Global Currency in Bucket Range 2
UNFULFILLED_AMT_SG_AGE_B3 NUMBER

Unfulfilled Amount in Secondary Global Currency in Bucket Range 3
UNFULFILLED_AMT_SG_AGE_B4 NUMBER

Unfulfilled Amount in Secondary Global Currency in Bucket Range 4
UNFULFILLED_AMT_SG_AGE_B5 NUMBER

Unfulfilled Amount in Secondary Global Currency in Bucket Range 5
UNFULFILLED_AMT_SG_AGE_B6 NUMBER

Unfulfilled Amount in Secondary Global Currency in Bucket Range 6
UNFULFILLED_AMT_SG_AGE_B7 NUMBER

Unfulfilled Amount in Secondary Global Currency in Bucket Range 7
UNFULFILLED_AMT_SG_AGE_B8 NUMBER

Unfulfilled Amount in Secondary Global Currency in Bucket Range 8
UNFULFILLED_AMT_SG_AGE_B9 NUMBER

Unfulfilled Amount in Secondary Global Currency in Bucket Range 9
UNFULFILLED_AMT_SG_AGE_B10 NUMBER

Unfulfilled Amount in Secondary Global Currency in Bucket Range 10
UNFULFILLED_CNT_AGE_B1 NUMBER

Number of Unfulfilled Requisition Lines in Bucket Range 1
UNFULFILLED_CNT_AGE_B2 NUMBER

Number of Unfulfilled Requisition Lines in Bucket Range 2
UNFULFILLED_CNT_AGE_B3 NUMBER

Number of Unfulfilled Requisition Lines in Bucket Range 3
UNFULFILLED_CNT_AGE_B4 NUMBER

Number of Unfulfilled Requisition Lines in Bucket Range 4
UNFULFILLED_CNT_AGE_B5 NUMBER

Number of Unfulfilled Requisition Lines in Bucket Range 5
UNFULFILLED_CNT_AGE_B6 NUMBER

Number of Unfulfilled Requisition Lines in Bucket Range 6
UNFULFILLED_CNT_AGE_B7 NUMBER

Number of Unfulfilled Requisition Lines in Bucket Range 7
UNFULFILLED_CNT_AGE_B8 NUMBER

Number of Unfulfilled Requisition Lines in Bucket Range 8
UNFULFILLED_CNT_AGE_B9 NUMBER

Number of Unfulfilled Requisition Lines in Bucket Range 9
UNFULFILLED_CNT_AGE_B10 NUMBER

Number of Unfulfilled Requisition Lines in Bucket Range 10
C_PEN_SRC_AMT_G NUMBER

Count Columns
C_PEN_BUYER_WK_AMT_G NUMBER

Count Columns
C_PEN_PO_SUBMIT_AMT_G NUMBER

Count Columns
C_PEN_PO_APPR_AMT_G NUMBER

Count Columns
C_UNPROCESSED_AMT_G NUMBER

Count Columns
C_PEN_FULFILL_AMT_G NUMBER

Count Columns
C_UNFULFILLED_AMT_G NUMBER

Count Columns
Query Text

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


SELECT AGGREGATION_LEVEL
,      CATEGORY_ID
,      PO_ITEM_ID
,      SUPPLIER_ID
,      BUYER_ID
,      SHIP_TO_ORG_ID
,      REQUESTER_ID
,      ORG_ID
,      BASE_UOM
,      NUM_DAYS_UNPROCESSED
,      NUM_DAYS_UNFULFILLED
,      PEN_SRC_AMT_G
,      PEN_SRC_AMT_B
,      PEN_SRC_AMT_SG
,      PEN_BUYER_WK_AMT_G
,      PEN_BUYER_WK_AMT_B
,      PEN_BUYER_WK_AMT_SG
,      PEN_PO_SUBMIT_AMT_G
,      PEN_PO_SUBMIT_AMT_B
,      PEN_PO_SUBMIT_AMT_SG
,      PEN_PO_APPR_AMT_G
,      PEN_PO_APPR_AMT_B
,      PEN_PO_APPR_AMT_SG
,      UNPROCESSED_AMT_G
,      UNPROCESSED_AMT_B
,      UNPROCESSED_AMT_SG
,      PEN_FULFILL_AMT_G
,      PEN_FULFILL_AMT_B
,      PEN_FULFILL_AMT_SG
,      UNFULFILLED_AMT_G
,      UNFULFILLED_AMT_B
,      UNFULFILLED_AMT_SG
,      PEN_SRC_CNT
,      PEN_BUYER_WK_CNT
,      PEN_PO_SUBMIT_CNT
,      PEN_PO_APPR_CNT
,      UNPROCESSED_CNT
,      PEN_FULFILL_CNT
,      UNFULFILLED_CNT
,      UNPROCESSED_PED_CNT
,      UNPROCESSED_EMER_CNT
,      UNPROCESSED_URG_CNT
,      UNFULFILLED_PED_CNT
,      UNPROCESSED_QTY
,      UNFULFILLED_QTY
,      UNFUL_PO_REVISIONS
,      UNPROCESSED_AMT_G_AGE_B1
,      UNPROCESSED_AMT_G_AGE_B2
,      UNPROCESSED_AMT_G_AGE_B3
,      UNPROCESSED_AMT_G_AGE_B4
,      UNPROCESSED_AMT_G_AGE_B5
,      UNPROCESSED_AMT_G_AGE_B6
,      UNPROCESSED_AMT_G_AGE_B7
,      UNPROCESSED_AMT_G_AGE_B8
,      UNPROCESSED_AMT_G_AGE_B9
,      UNPROCESSED_AMT_G_AGE_B10
,      UNPROCESSED_AMT_B_AGE_B1
,      UNPROCESSED_AMT_B_AGE_B2
,      UNPROCESSED_AMT_B_AGE_B3
,      UNPROCESSED_AMT_B_AGE_B4
,      UNPROCESSED_AMT_B_AGE_B5
,      UNPROCESSED_AMT_B_AGE_B6
,      UNPROCESSED_AMT_B_AGE_B7
,      UNPROCESSED_AMT_B_AGE_B8
,      UNPROCESSED_AMT_B_AGE_B9
,      UNPROCESSED_AMT_B_AGE_B10
,      UNPROCESSED_AMT_SG_AGE_B1
,      UNPROCESSED_AMT_SG_AGE_B2
,      UNPROCESSED_AMT_SG_AGE_B3
,      UNPROCESSED_AMT_SG_AGE_B4
,      UNPROCESSED_AMT_SG_AGE_B5
,      UNPROCESSED_AMT_SG_AGE_B6
,      UNPROCESSED_AMT_SG_AGE_B7
,      UNPROCESSED_AMT_SG_AGE_B8
,      UNPROCESSED_AMT_SG_AGE_B9
,      UNPROCESSED_AMT_SG_AGE_B10
,      UNPROCESSED_CNT_AGE_B1
,      UNPROCESSED_CNT_AGE_B2
,      UNPROCESSED_CNT_AGE_B3
,      UNPROCESSED_CNT_AGE_B4
,      UNPROCESSED_CNT_AGE_B5
,      UNPROCESSED_CNT_AGE_B6
,      UNPROCESSED_CNT_AGE_B7
,      UNPROCESSED_CNT_AGE_B8
,      UNPROCESSED_CNT_AGE_B9
,      UNPROCESSED_CNT_AGE_B10
,      UNFULFILLED_AMT_G_AGE_B1
,      UNFULFILLED_AMT_G_AGE_B2
,      UNFULFILLED_AMT_G_AGE_B3
,      UNFULFILLED_AMT_G_AGE_B4
,      UNFULFILLED_AMT_G_AGE_B5
,      UNFULFILLED_AMT_G_AGE_B6
,      UNFULFILLED_AMT_G_AGE_B7
,      UNFULFILLED_AMT_G_AGE_B8
,      UNFULFILLED_AMT_G_AGE_B9
,      UNFULFILLED_AMT_G_AGE_B10
,      UNFULFILLED_AMT_B_AGE_B1
,      UNFULFILLED_AMT_B_AGE_B2
,      UNFULFILLED_AMT_B_AGE_B3
,      UNFULFILLED_AMT_B_AGE_B4
,      UNFULFILLED_AMT_B_AGE_B5
,      UNFULFILLED_AMT_B_AGE_B6
,      UNFULFILLED_AMT_B_AGE_B7
,      UNFULFILLED_AMT_B_AGE_B8
,      UNFULFILLED_AMT_B_AGE_B9
,      UNFULFILLED_AMT_B_AGE_B10
,      UNFULFILLED_AMT_SG_AGE_B1
,      UNFULFILLED_AMT_SG_AGE_B2
,      UNFULFILLED_AMT_SG_AGE_B3
,      UNFULFILLED_AMT_SG_AGE_B4
,      UNFULFILLED_AMT_SG_AGE_B5
,      UNFULFILLED_AMT_SG_AGE_B6
,      UNFULFILLED_AMT_SG_AGE_B7
,      UNFULFILLED_AMT_SG_AGE_B8
,      UNFULFILLED_AMT_SG_AGE_B9
,      UNFULFILLED_AMT_SG_AGE_B10
,      UNFULFILLED_CNT_AGE_B1
,      UNFULFILLED_CNT_AGE_B2
,      UNFULFILLED_CNT_AGE_B3
,      UNFULFILLED_CNT_AGE_B4
,      UNFULFILLED_CNT_AGE_B5
,      UNFULFILLED_CNT_AGE_B6
,      UNFULFILLED_CNT_AGE_B7
,      UNFULFILLED_CNT_AGE_B8
,      UNFULFILLED_CNT_AGE_B9
,      UNFULFILLED_CNT_AGE_B10
,      C_PEN_SRC_AMT_G
,      C_PEN_BUYER_WK_AMT_G
,      C_PEN_PO_SUBMIT_AMT_G
,      C_PEN_PO_APPR_AMT_G
,      C_UNPROCESSED_AMT_G
,      C_PEN_FULFILL_AMT_G
,      C_UNFULFILLED_AMT_G
FROM APPS.POA_REQ_000_MV;

Dependencies

[top of page]

APPS.POA_REQ_000_MV references the following:

SchemaAPPS
TablePOA_REQ_000_MV
SchemaBIS
TableBIS_BUCKET
TableBIS_BUCKET_CUSTOMIZATIONS
TableBIS_REFRESH_LOG
SchemaPOA
TablePOA_DBI_REQ_F

APPS.POA_REQ_000_MV is not referenced by any database object