[Home] [Help] [Dependency Information]
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
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CSP_REPAIR_PO_HEADERS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | REPAIR_PO_HEADER_ID |
CSP_REPAIR_PO_HEADERS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
STATUS
REPAIR_PO_HEADER_ID |
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 |
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;
CSP.CSP_REPAIR_PO_HEADERS does not reference any database object
CSP.CSP_REPAIR_PO_HEADERS is referenced by following:
|
|
|