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

MATERIALIZED VIEW: APPS.POA_POD_BS_J_MV

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

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
CRID ROWID (10)
CRID
COMRID ROWID (10)
COMRID
MRID ROWID (10)
MRID
ORG_ID NUMBER

Operating Unit Identifier
COMMODITY_ID NUMBER

Commodity Identifier
BASE_UOM VARCHAR2 (25)
Base UOM
SUPPLIER_ID NUMBER

Supplier Identifier
SUPPLIER_SITE_ID NUMBER

Supplier Site Identifier
CATEGORY_ID NUMBER

Category on the PO Line Identifier
PO_ITEM_ID NUMBER
Yes Purchased Item Identifier
BUYER_ID NUMBER
Yes Buyer Identifier
SHIPMENT_TYPE VARCHAR2 (25)
Shipment Type
COMPANY_ID NUMBER (15)
Company Identifier
COST_CENTER_ID NUMBER (15)
Cost-center Identifier
ENT_YEAR_ID NUMBER

Enterprise Year 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
QUANTITY NUMBER

Quantity in Base UOM
PURCHASE_AMT_B NUMBER

Purchase Amount in Functional Currency
PURCHASE_AMT_G NUMBER

Purchase Amount in Global Currency
PURCHASE_AMT_SG NUMBER

Purchase Amount in Secondary Global Currency
P_CONTRACT_AMT_B NUMBER

Contract Leakage Amount in Functional Currency
P_CONTRACT_AMT_G NUMBER

Contract Leakage Amount in Global Currency
P_CONTRACT_AMT_SG NUMBER

Contract Leakage Amount in Secondary Global Currency
N_CONTRACT_AMT_B NUMBER

Non-Contract Amount in Functional Currency
N_CONTRACT_AMT_G NUMBER

Non-Contract Amount in Global Currency
N_CONTRACT_AMT_SG NUMBER

Non-Contract Amount in Secondary Global Currency
P_SAVINGS_AMT_B NUMBER

Potential Savings Amount in Functional Currency
P_SAVINGS_AMT_G NUMBER

Potential Savings Amount in Global Currency
P_SAVINGS_AMT_SG NUMBER

Potential Savings Amount in Secondary Global Currency
CONTRACT_AMT_B NUMBER

Contract Amount in Functional Currency
CONTRACT_AMT_G NUMBER

Contract Amount in Global Currency
CONTRACT_AMT_SG NUMBER

Contract Amount in secondary Global Currency
BELOW_CONTRACT_AMT_B NUMBER

Difference between the PO Amount and the potential contract amount, where the PO Amount was less than the contract amount in Functional Currency.
BELOW_CONTRACT_AMT_G NUMBER

Difference between the PO Amount and the potential contract amount, where the PO Amount was less than the contract amount in Global Currency.
BELOW_CONTRACT_AMT_SG NUMBER

Difference between the PO Amount and the potential contract amount, where the PO Amount was less than the contract amount in Secondary Global Currency.
ABOVE_CONTRACT_AMT_B NUMBER

Difference between the PO Amount and the potential contract amount, where the PO Amount was greater than the contract amount in Function Currency.
ABOVE_CONTRACT_AMT_G NUMBER

Difference between the PO Amount and the potential contract amount, where the PO Amount was greater than the contract amount in Global Currency.
ABOVE_CONTRACT_AMT_SG NUMBER

Difference between the PO Amount and the potential contract amount, where the PO Amount was greater than the contract amount in secondary Global Currency.
CONSIGNED_CODE NUMBER

Consigned Code - 0 for normal shipment, 1 for consigned shipment, 2 for consumption advice
NZ_QUANTITY NUMBER

Non Zero Quantity
AUCTION_HEADER_ID NUMBER

Negotiation Header Identifier
AUCTION_LINE_NUMBER NUMBER

Negotiation Line Number
BID_NUMBER NUMBER

Negotiation Bid Number
BID_LINE_NUMBER NUMBER

Negotiation Bid Line Number
PO_RELEASE_ID NUMBER

PO Release Identifier
PO_HEADER_ID NUMBER
Yes PO Header Identifier
NEGOTIATION_CREATOR_ID NUMBER

Negotiation Creator Identifier
DOCTYPE_ID NUMBER

Negotiation Document Type Identifier
CURRENT_AMT_B NUMBER

Negotiation Amount at Current Price in functional currency
CURRENT_AMT_G NUMBER

Negotiation Amount at Current Price in global currency
CURRENT_AMT_SG NUMBER

Negotiation Amount at Current Price in secondary global currency
CONTRACT_TYPE NUMBER

1 for Blkt Releases, 2 for Scheduled Releases, 3 for PO referencing Global Agrmt, 4 for PO with Negotiated Pricing
Query Text

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


SELECT FRID
,      CRID
,      COMRID
,      MRID
,      ORG_ID
,      COMMODITY_ID
,      BASE_UOM
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      CATEGORY_ID
,      PO_ITEM_ID
,      BUYER_ID
,      SHIPMENT_TYPE
,      COMPANY_ID
,      COST_CENTER_ID
,      ENT_YEAR_ID
,      ENT_QTR_ID
,      ENT_PERIOD_ID
,      WEEK_ID
,      DAY_ID
,      QUANTITY
,      PURCHASE_AMT_B
,      PURCHASE_AMT_G
,      PURCHASE_AMT_SG
,      P_CONTRACT_AMT_B
,      P_CONTRACT_AMT_G
,      P_CONTRACT_AMT_SG
,      N_CONTRACT_AMT_B
,      N_CONTRACT_AMT_G
,      N_CONTRACT_AMT_SG
,      P_SAVINGS_AMT_B
,      P_SAVINGS_AMT_G
,      P_SAVINGS_AMT_SG
,      CONTRACT_AMT_B
,      CONTRACT_AMT_G
,      CONTRACT_AMT_SG
,      BELOW_CONTRACT_AMT_B
,      BELOW_CONTRACT_AMT_G
,      BELOW_CONTRACT_AMT_SG
,      ABOVE_CONTRACT_AMT_B
,      ABOVE_CONTRACT_AMT_G
,      ABOVE_CONTRACT_AMT_SG
,      CONSIGNED_CODE
,      NZ_QUANTITY
,      AUCTION_HEADER_ID
,      AUCTION_LINE_NUMBER
,      BID_NUMBER
,      BID_LINE_NUMBER
,      PO_RELEASE_ID
,      PO_HEADER_ID
,      NEGOTIATION_CREATOR_ID
,      DOCTYPE_ID
,      CURRENT_AMT_B
,      CURRENT_AMT_G
,      CURRENT_AMT_SG
,      CONTRACT_TYPE
FROM APPS.POA_POD_BS_J_MV;

Dependencies

[top of page]

APPS.POA_POD_BS_J_MV references the following:

SchemaAPPS
TablePOA_POD_BS_J_MV
SchemaFII
TableFII_COM_CC_DIM_MAPS
TableFII_TIME_DAY
SchemaPO
TablePO_COMMODITY_CATEGORIES
SchemaPOA
TablePOA_DBI_POD_F
APPS.POA_POD_BS_J_MV is referenced by following:

SchemaAPPS
Materialized ViewPOA_POD_001_MV
Materialized ViewPOA_POD_BS_MV