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


TABLE: OPI.OPI_DBI_INV_CCA_STG

Object Details
Object Name: OPI_DBI_INV_CCA_STG
Object Type: TABLE
Owner: OPI
Subobject Name:
Status: VALID


Staging table for extraction of inventory cycle count accuracy and adjustment data.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER
Yes Organization ID for organization to which the cycle count entry belongs.
INVENTORY_ITEM_ID NUMBER
Yes Inventory Item ID of item for which the cycle count entry was created.
CYCLE_COUNT_HEADER_ID NUMBER
Yes Internal ID for the cycle count to which the entry belongs.
ABC_CLASS_ID VARCHAR2 (40) Yes ABC class ID to which this item was assigned for the cycle count.
SUBINVENTORY_CODE VARCHAR2 (10) Yes Subinventory to which the count entry is associated.
CYCLE_COUNT_ENTRY_ID VARCHAR2 (40) Yes Entry ID for the cycle count entry. Primary key for this table and foreign key to MTL_CYCLE_COUNT_ENTRIES.
SOURCE NUMBER
Yes Data source. 1 = OPI, 2 = OPM.
APPROVAL_DATE DATE
Yes Date on which the cycle count entry was approved.
UOM_CODE VARCHAR2 (3) Yes Primary UOM for this Item/Organization combination.
SYSTEM_INVENTORY_QTY NUMBER

Counted system quantity for the entry in the primary UOM.
POSITIVE_ADJUSTMENT_QTY NUMBER

Quantity of adjustment (if greater than 0).
NEGATIVE_ADJUSTMENT_QTY NUMBER

Quantity of adjustment (if less than 0).
ITEM_UNIT_COST NUMBER

Item cost of one unit in the primary UOM at the time of the cycle count entry.
ITEM_ADJ_UNIT_COST NUMBER

Item cost of one unit in the primary UOM at the time of when the adjustment was costed.
HIT_MISS_POS NUMBER

Positive Hit/Miss tolerance.
HIT_MISS_NEG NUMBER

Negative Hit/Miss tolerance.
EXACT_MATCH NUMBER

Exact match marker. 0 = not a match, 1 = exact match.
Query Text

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


SELECT ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      CYCLE_COUNT_HEADER_ID
,      ABC_CLASS_ID
,      SUBINVENTORY_CODE
,      CYCLE_COUNT_ENTRY_ID
,      SOURCE
,      APPROVAL_DATE
,      UOM_CODE
,      SYSTEM_INVENTORY_QTY
,      POSITIVE_ADJUSTMENT_QTY
,      NEGATIVE_ADJUSTMENT_QTY
,      ITEM_UNIT_COST
,      ITEM_ADJ_UNIT_COST
,      HIT_MISS_POS
,      HIT_MISS_NEG
,      EXACT_MATCH
FROM OPI.OPI_DBI_INV_CCA_STG;

Dependencies

[top of page]

OPI.OPI_DBI_INV_CCA_STG does not reference any database object

OPI.OPI_DBI_INV_CCA_STG is referenced by following:

SchemaAPPS
SynonymOPI_DBI_INV_CCA_STG