[Home] [Help] [Dependency Information]
Object Name: | POA_RTX_BS_J_MV |
---|---|
Object Type: | MATERIALIZED VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Container: | POA_RTX_BS_J_MV |
---|---|
Updatable: | N |
Rewrite Enabled: | N |
Rewrite Capability: | GENERAL |
Refresh Mode: | DEMAND |
Refresh Method: | FAST |
Build Mode: | DEFERRED |
Fast Refreshable: | DIRLOAD_DML |
FII_TIME_DAY
OKI_DBI_MULTIPLEXER_B
POA_DBI_PLL_MV
POA_DBI_POD_F
PO_COMMODITY_CATEGORIES
POA_DBI_RTX_F
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RRID | ROWID | (10) | RRID | |
PRID | ROWID | (10) | PRID | |
CRID | ROWID | (10) | CRID | |
MXROWID | ROWID | (10) | MXROWID | |
COMMODITY_ID | NUMBER | Commodity Identifier | ||
CATEGORY_ID | NUMBER | Category on the PO Line Identifier | ||
PO_ITEM_ID | NUMBER | Yes | Purchased Item Identifier | |
ORG_ID | NUMBER | Operating Unit Identifier | ||
SUPPLIER_ID | NUMBER | Supplier Identifier | ||
SUPPLIER_SITE_ID | NUMBER | Supplier Site Identifier | ||
BUYER_ID | NUMBER | Yes | Buyer Identifier | |
RECEIVING_ORG_ID | NUMBER | Receiving Organization Identifier | ||
REASON_ID | NUMBER | Return Reason Identifier | ||
BASE_UOM | VARCHAR2 | (25) | Base UOM | |
TRANSACTION_TYPE | VARCHAR2 | (25) | Yes | Transaction type from receiving transactions table, values:ACCEPT, CORRECT, MATCH, RECEIVE, REJECT, RETURN TO VENDOR |
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 | |
MX_ID | NUMBER | Yes | Multiplexer Identifier | |
QUANTITY | NUMBER | Quantity in Base UOM | ||
AMOUNT_B | NUMBER | Receipt or Return Amount in functional currency | ||
AMOUNT_G | NUMBER | Receipt or Return Amount in global currency | ||
AMOUNT_SG | NUMBER | Receipt or Return Amount in secondary global currency | ||
AMT_AFTERDUE_B | NUMBER | Amount Received after late tolerance in functional currency | ||
AMT_AFTERDUE_G | NUMBER | Amount Received after late tolerance in global currency | ||
AMT_AFTERDUE_SG | NUMBER | Amount Received after late tolerance in secondary global currency | ||
AMT_BEFOREDUE_B | NUMBER | Amount Received before early tolerance in functional currency | ||
AMT_BEFOREDUE_G | NUMBER | Amount Received before early tolerance in global currency | ||
AMT_BEFOREDUE_SG | NUMBER | Amount Received before early tolerance in secondary global currency | ||
AMT_EXPT_B | NUMBER | Amount Received outside tolerance in functional currency | ||
AMT_EXPT_G | NUMBER | Amount Received outside tolerance in global currency | ||
AMT_EXPT_SG | NUMBER | Amount Received outside tolerance in secondary global currency | ||
QTY_INTOL | NUMBER | Quantity received in tolerance | ||
QTY_AFTERDUE | NUMBER | Quantity received after late tolerance | ||
QTY_BEFOREDUE | NUMBER | Quantity recieved before early tolerance | ||
NUM_DAYS_LATE | NUMBER | the number of days late the receipt transactions took place | ||
NUM_DAYS_EARLY | NUMBER | the number of days early the receipt transactions took place | ||
TRANSACTION_FLAG | VARCHAR2 | (16) | Transaction type, values: ACCEPT, RECEIVE, REJECT, RETURN TO VENDOR | |
DROPSHIP_TYPE_CODE | NUMBER | Dropship type for global procurement |
Cut, paste (and edit) the following text to query this object:
SELECT RRID
, PRID
, CRID
, MXROWID
, COMMODITY_ID
, CATEGORY_ID
, PO_ITEM_ID
, ORG_ID
, SUPPLIER_ID
, SUPPLIER_SITE_ID
, BUYER_ID
, RECEIVING_ORG_ID
, REASON_ID
, BASE_UOM
, TRANSACTION_TYPE
, ENT_YEAR_ID
, ENT_QTR_ID
, ENT_PERIOD_ID
, WEEK_ID
, DAY_ID
, MX_ID
, QUANTITY
, AMOUNT_B
, AMOUNT_G
, AMOUNT_SG
, AMT_AFTERDUE_B
, AMT_AFTERDUE_G
, AMT_AFTERDUE_SG
, AMT_BEFOREDUE_B
, AMT_BEFOREDUE_G
, AMT_BEFOREDUE_SG
, AMT_EXPT_B
, AMT_EXPT_G
, AMT_EXPT_SG
, QTY_INTOL
, QTY_AFTERDUE
, QTY_BEFOREDUE
, NUM_DAYS_LATE
, NUM_DAYS_EARLY
, TRANSACTION_FLAG
, DROPSHIP_TYPE_CODE
FROM APPS.POA_RTX_BS_J_MV;
|
|
|