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

TABLE: CSP.CSP_REPAIR_PO_HEADERS

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


CSP_REPAIR_PO_HEADERS stores information about all the Repair Purchase Order.
PURCHASE_ORDER_HEADER_ID identifies the Purchase Order header_id
REQUISITION_HEADER_ID identifies the Repair Purchase Order Requisition Id


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CSP_REPAIR_PO_HEADERS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREPAIR_PO_HEADER_ID
CSP_REPAIR_PO_HEADERS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTATUS
ColumnREPAIR_PO_HEADER_ID
Columns
Name Datatype Length Mandatory Comments
REPAIR_PO_HEADER_ID NUMBER
Yes Repair purchase order header identifier
REQUISITION_HEADER_ID NUMBER
Yes Requisition header identifier
PURCHASE_ORDER_HEADER_ID NUMBER

Purchase order header identifier
INTERNAL_ORDER_HEADER_ID NUMBER

Internal order header identifier
WIP_ID NUMBER

WIP identifier
STATUS VARCHAR2 (240)
Repair purchase order status
INVENTORY_ITEM_ID NUMBER

Item identifier
QUANTITY NUMBER

Quantity
DEST_ORGANIZATION_ID NUMBER

Destination organization identifier
NEED_BY_DATE DATE

Need by date
REQUISITION_NUMBER VARCHAR2 (240) Yes Requisition number
REQUISITION_LINE_ID NUMBER

Requisition line identifier
ORDER_LINE_ID NUMBER

Order line identifier
LINE_NUM NUMBER

Line number
POREQ_LINE_RESERVATION_ID NUMBER

Purchase requisition line reservation identifier
POREQ_LINE_ID NUMBER

Purchase requisition line identifier
ERROR_MESSAGE VARCHAR2 (240)
Error message
REPAIR_PROGRAM VARCHAR2 (240)
Repair program
PO_NUMBER VARCHAR2 (20)
Purchase order number
REPAIR_SUPPLIER_ID NUMBER

Repair supplier identifier
REPAIR_SUPPLIER_ORG_ID NUMBER

Repair supplier organization identifier
RECEIVED_QTY NUMBER

Received quantity
Query Text

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


SELECT REPAIR_PO_HEADER_ID
,      REQUISITION_HEADER_ID
,      PURCHASE_ORDER_HEADER_ID
,      INTERNAL_ORDER_HEADER_ID
,      WIP_ID
,      STATUS
,      INVENTORY_ITEM_ID
,      QUANTITY
,      DEST_ORGANIZATION_ID
,      NEED_BY_DATE
,      REQUISITION_NUMBER
,      REQUISITION_LINE_ID
,      ORDER_LINE_ID
,      LINE_NUM
,      POREQ_LINE_RESERVATION_ID
,      POREQ_LINE_ID
,      ERROR_MESSAGE
,      REPAIR_PROGRAM
,      PO_NUMBER
,      REPAIR_SUPPLIER_ID
,      REPAIR_SUPPLIER_ORG_ID
,      RECEIVED_QTY
FROM CSP.CSP_REPAIR_PO_HEADERS;

Dependencies

[top of page]

CSP.CSP_REPAIR_PO_HEADERS does not reference any database object

CSP.CSP_REPAIR_PO_HEADERS is referenced by following:

SchemaCSP
ViewCSP_REPAIR_PO_HEADERS#