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

TABLE: CSP.CSP_REPAIR_PO_LINES

Object Details
Object Name: CSP_REPAIR_PO_LINES
Object Type: TABLE
Owner: CSP
Subobject Name:
Status: VALID


This table contains the details of Repair purchase orders defective item, Quantity, Defective Org, Received Qty (at repair supplier), Scrap Qty, Adjusted Qty, Scrap Date, Adjustment Date andRepair PO Header ID.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CSP_REPAIR_PO_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREPAIR_PO_LINE_ID
CSP_REPAIR_PO_LINES_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVENTORY_ITEM_ID
ColumnREPAIR_PO_HEADER_ID
CSP_REPAIR_PO_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREPAIR_PO_HEADER_ID
Columns
Name Datatype Length Mandatory Comments
REPAIR_PO_LINE_ID NUMBER
Yes Repair purchase order line identifier
REPAIR_PO_HEADER_ID NUMBER
Yes Repair purchase order header identifier
DEFECTIVE_ORGANIZATION_ID NUMBER

Defective organization identifier
INVENTORY_ITEM_ID NUMBER

Item identifier
QUANTITY NUMBER

Quantity
RESERVATION_ID NUMBER

Reservation identifier
RECEIVED_QTY NUMBER

Received internal order qty
SCRAP_QTY NUMBER

Scrap Quantity
ADJUSTED_QTY NUMBER

Adjustment qty
SCRAP_DATE DATE

Scrap Date
ADJUSTMENT_DATE DATE

Adjustment Date
Query Text

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


SELECT REPAIR_PO_LINE_ID
,      REPAIR_PO_HEADER_ID
,      DEFECTIVE_ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      QUANTITY
,      RESERVATION_ID
,      RECEIVED_QTY
,      SCRAP_QTY
,      ADJUSTED_QTY
,      SCRAP_DATE
,      ADJUSTMENT_DATE
FROM CSP.CSP_REPAIR_PO_LINES;

Dependencies

[top of page]

CSP.CSP_REPAIR_PO_LINES does not reference any database object

CSP.CSP_REPAIR_PO_LINES is referenced by following:

SchemaAPPS
SynonymCSP_REPAIR_PO_LINES