[Home] [Help]
[Dependency Information]
[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;
APPS
POA_DBI_PLL_MV
POA_DBI_PLL_MV
POA_RTX_BS_J_MV
FII
FII_TIME_DAY
OKI
OKI_DBI_MULTIPLEXER_B
POA
POA_DBI_RTX_F
APPS
POA_RTX_BS_MV
|
|
|
|