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

TABLE: APPS.POA_RTX_BS_MV

Object Details
Object Name: POA_RTX_BS_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.POA_RTX_BS_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
I_SNAP$_POA_RTX_BS_MV FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnSYS_OP_MAP_NONNULL("ORG_ID")
ColumnSYS_OP_MAP_NONNULL("COMMODITY_ID")
ColumnSYS_OP_MAP_NONNULL("SUPPLIER_ID")
ColumnSYS_OP_MAP_NONNULL("CATEGORY_ID")
ColumnSYS_OP_MAP_NONNULL("PO_ITEM_ID")
ColumnSYS_OP_MAP_NONNULL("SUPPLIER_SITE_ID")
ColumnSYS_OP_MAP_NONNULL("RECEIVING_ORG_ID")
ColumnSYS_OP_MAP_NONNULL("BUYER_ID")
ColumnSYS_OP_MAP_NONNULL("REASON_ID")
ColumnSYS_OP_MAP_NONNULL("BASE_UOM")
ColumnSYS_OP_MAP_NONNULL("ENT_QTR_ID")
ColumnSYS_OP_MAP_NONNULL("ENT_PERIOD_ID")
ColumnSYS_OP_MAP_NONNULL("WEEK_ID")
ColumnSYS_OP_MAP_NONNULL("DAY_ID")
ColumnSYS_OP_MAP_NONNULL("ENT_YEAR_ID")
ColumnSYS_OP_MAP_NONNULL("GRP_ID")
ColumnSYS_OP_MAP_NONNULL("AGGREGATION_LEVEL")
POA_RTX_BS_MV_N1 NORMAL NONUNIQUE Tablespace ColumnTIME_ID
ColumnCOMMODITY_ID
ColumnCATEGORY_ID
ColumnPO_ITEM_ID
POA_RTX_BS_MV_N2 NORMAL NONUNIQUE Tablespace ColumnTIME_ID
ColumnCOMMODITY_ID
ColumnSUPPLIER_ID
ColumnSUPPLIER_SITE_ID
POA_RTX_BS_MV_N3 NORMAL NONUNIQUE Tablespace ColumnTIME_ID
ColumnCOMMODITY_ID
ColumnRECEIVING_ORG_ID
ColumnBUYER_ID
ColumnREASON_ID
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

Nested Grouping ID Column for Period Type
AGGREGATION_LEVEL NUMBER

Grouping ID Column
COMMODITY_ID NUMBER

Commodity Identifier
CATEGORY_ID NUMBER

Category on the PO Line Identifier
PO_ITEM_ID NUMBER

Purchased Item Identifier
ORG_ID NUMBER

Operating Unit Identifier
SUPPLIER_ID NUMBER

Supplier Identifier
SUPPLIER_SITE_ID NUMBER

Supplier Site Identifier
RECEIVING_ORG_ID NUMBER

Receiving Organization Identifier
BUYER_ID NUMBER

Buyer Identifier
REASON_ID NUMBER

Return Reason 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
AMT_RECEIPT_AND_DROPSHIP_B NUMBER

Receipt amount excluding dropship transactions in functional currency
AMT_RECEIPT_AND_DROPSHIP_G NUMBER

Receipt amount excluding dropship transactions in primary global currency
AMT_RECEIPT_AND_DROPSHIP_SG NUMBER

Receipt amount excluding dropship transactions in secondary global currency
AMT_RECEIPT_B NUMBER

Receipt Amount in functional currency
AMT_RECEIPT_G NUMBER

Receipt Amount in global currency
AMT_RECEIPT_SG NUMBER

Receipt Amount in secondary global currency
AMT_RETURN_B NUMBER

Amount returned aggregated based on inspection date in functional currency
AMT_RETURN_G NUMBER

Amount returned aggregated based on inspection date in global currency
AMT_RETURN_SG NUMBER

Amount returned aggregated based on inspection date in secondary global currency
AMT_RECEIPT_RETURN_B NUMBER

Amount Returned aggregated based on Receipt Date in functional currency
AMT_RECEIPT_RETURN_G NUMBER

Amount Returned aggregated based on Receipt Date in global currency
AMT_RECEIPT_RETURN_SG NUMBER

Amount Returned aggregated based on Receipt Date in secondary global currency
QTY_RECEIPT_AND_DROPSHIP NUMBER

Receipt quantity excluding dropship transactions
QTY_RECEIPT NUMBER

Quantity Received
QTY_RETURN NUMBER

Quantity Returned
QTY_REJECT NUMBER

Quantity Rejected
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_EARLY NUMBER

the number of days early the receipt transactions took place
NUM_DAYS_LATE NUMBER

the number of days late the receipt transactions took place
AMT_REJECT_B NUMBER

Amount rejected aggregated based on inspection date in functional currency
AMT_REJECT_G NUMBER

Amount rejected aggregated based on inspection date in global currency
AMT_REJECT_SG NUMBER

Amount rejected aggregated based on inspection date in secondary global currency
AMT_INSPECTED_B NUMBER

Receipt Amount inspected in functional currency
AMT_INSPECTED_G NUMBER

Receipt Amount inspected in global currency
AMT_INSPECTED_SG NUMBER

Receipt Amount inspected in secondary global currency
AMT_RECEIPT_REJECT_B NUMBER

Amount Rejected aggregated based on Receipt Date in functional currency
AMT_RECEIPT_REJECT_G NUMBER

Amount Rejected aggregated based on Receipt Date in global currency
AMT_RECEIPT_REJECT_SG NUMBER

Amount Rejected aggregated based on Receipt Date in gsecondary lobal currency
C_AMT_RECEIPT_AND_DROPSHIP_B NUMBER

Count Columns
C_AMT_RECEIPT_AND_DROPSHIP_G NUMBER

Count Columns
C_AMT_RECEIPT_AND_DROPSHIP_SG NUMBER

Count Columns
C_AMT_RECEIPT_B NUMBER

Count Columns
C_AMT_RECEIPT_G NUMBER

Count Columns
C_AMT_RECEIPT_SG NUMBER

Count Columns
C_AMT_RETURN_B NUMBER

Count Columns
C_AMT_RETURN_G NUMBER

Count Columns
C_AMT_RETURN_SG NUMBER

Count Columns
C_AMT_RECEIPT_RETURN_B NUMBER

Count Columns
C_AMT_RECEIPT_RETURN_G NUMBER

Count Columns
C_AMT_RECEIPT_RETURN_SG NUMBER

Count Columns
C_QTY_RECEIPT_AND_DROPSHIP NUMBER

Count Columns
C_QTY_RECEIPT NUMBER

Count Columns
C_QTY_RETURN NUMBER

Count Columns
C_QTY_REJECT NUMBER

Count Columns
C_AMT_AFTERDUE_B NUMBER

Count Columns
C_AMT_AFTERDUE_G NUMBER

Count Columns
C_AMT_AFTERDUE_SG NUMBER

Count Columns
C_AMT_BEFOREDUE_B NUMBER

Count Columns
C_AMT_BEFOREDUE_G NUMBER

Count Columns
C_AMT_BEFOREDUE_SG NUMBER

Count Columns
C_AMT_EXPT_B NUMBER

Count Columns
C_AMT_EXPT_G NUMBER

Count Columns
C_AMT_EXPT_SG NUMBER

Count Columns
C_QTY_INTOL NUMBER

Count Columns
C_QTY_AFTERDUE NUMBER

Count Columns
C_QTY_BEFOREDUE NUMBER

Count Columns
NUM_TXNS_EARLY_CNT NUMBER

The number of receipt transactions that were early
NUM_TXNS_LATE_CNT NUMBER

The number of receipt transactions that were late
C_AMT_REJECT_B NUMBER

Count Columns
C_AMT_REJECT_G NUMBER

Count Columns
C_AMT_REJECT_SG NUMBER

Count Columns
C_AMT_INSPECTED_B NUMBER

Count Columns
C_AMT_INSPECTED_G NUMBER

Count Columns
C_AMT_INSPECTED_SG NUMBER

Count Columns
C_AMT_RECEIPT_REJECT_B NUMBER

Count Columns
C_AMT_RECEIPT_REJECT_G NUMBER

Count Columns
C_AMT_RECEIPT_REJECT_SG NUMBER

Count Columns
C_TOTAL NUMBER

Row Count
NUM_TXNS_RECEIPT_CNT NUMBER

The number of receipt transactions
NUM_TXNS_RETURN_CNT NUMBER

The number of return transactions
NUM_TXNS_RECEIPT_RETURN_CNT NUMBER

The number of Receipt Returned transactions
Query Text

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


SELECT GRP_ID
,      TIME_ID
,      PERIOD_TYPE_ID
,      AGGREGATION_LEVEL
,      COMMODITY_ID
,      CATEGORY_ID
,      PO_ITEM_ID
,      ORG_ID
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      RECEIVING_ORG_ID
,      BUYER_ID
,      REASON_ID
,      BASE_UOM
,      ENT_YEAR_ID
,      ENT_QTR_ID
,      ENT_PERIOD_ID
,      WEEK_ID
,      DAY_ID
,      AMT_RECEIPT_AND_DROPSHIP_B
,      AMT_RECEIPT_AND_DROPSHIP_G
,      AMT_RECEIPT_AND_DROPSHIP_SG
,      AMT_RECEIPT_B
,      AMT_RECEIPT_G
,      AMT_RECEIPT_SG
,      AMT_RETURN_B
,      AMT_RETURN_G
,      AMT_RETURN_SG
,      AMT_RECEIPT_RETURN_B
,      AMT_RECEIPT_RETURN_G
,      AMT_RECEIPT_RETURN_SG
,      QTY_RECEIPT_AND_DROPSHIP
,      QTY_RECEIPT
,      QTY_RETURN
,      QTY_REJECT
,      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_EARLY
,      NUM_DAYS_LATE
,      AMT_REJECT_B
,      AMT_REJECT_G
,      AMT_REJECT_SG
,      AMT_INSPECTED_B
,      AMT_INSPECTED_G
,      AMT_INSPECTED_SG
,      AMT_RECEIPT_REJECT_B
,      AMT_RECEIPT_REJECT_G
,      AMT_RECEIPT_REJECT_SG
,      C_AMT_RECEIPT_AND_DROPSHIP_B
,      C_AMT_RECEIPT_AND_DROPSHIP_G
,      C_AMT_RECEIPT_AND_DROPSHIP_SG
,      C_AMT_RECEIPT_B
,      C_AMT_RECEIPT_G
,      C_AMT_RECEIPT_SG
,      C_AMT_RETURN_B
,      C_AMT_RETURN_G
,      C_AMT_RETURN_SG
,      C_AMT_RECEIPT_RETURN_B
,      C_AMT_RECEIPT_RETURN_G
,      C_AMT_RECEIPT_RETURN_SG
,      C_QTY_RECEIPT_AND_DROPSHIP
,      C_QTY_RECEIPT
,      C_QTY_RETURN
,      C_QTY_REJECT
,      C_AMT_AFTERDUE_B
,      C_AMT_AFTERDUE_G
,      C_AMT_AFTERDUE_SG
,      C_AMT_BEFOREDUE_B
,      C_AMT_BEFOREDUE_G
,      C_AMT_BEFOREDUE_SG
,      C_AMT_EXPT_B
,      C_AMT_EXPT_G
,      C_AMT_EXPT_SG
,      C_QTY_INTOL
,      C_QTY_AFTERDUE
,      C_QTY_BEFOREDUE
,      NUM_TXNS_EARLY_CNT
,      NUM_TXNS_LATE_CNT
,      C_AMT_REJECT_B
,      C_AMT_REJECT_G
,      C_AMT_REJECT_SG
,      C_AMT_INSPECTED_B
,      C_AMT_INSPECTED_G
,      C_AMT_INSPECTED_SG
,      C_AMT_RECEIPT_REJECT_B
,      C_AMT_RECEIPT_REJECT_G
,      C_AMT_RECEIPT_REJECT_SG
,      C_TOTAL
,      NUM_TXNS_RECEIPT_CNT
,      NUM_TXNS_RETURN_CNT
,      NUM_TXNS_RECEIPT_RETURN_CNT
FROM APPS.POA_RTX_BS_MV;

Dependencies

[top of page]

APPS.POA_RTX_BS_MV does not reference any database object

APPS.POA_RTX_BS_MV is referenced by following:

SchemaAPPS
Materialized ViewPOA_RTX_BS_MV