[Home] [Help] [Dependency Information]
Object Name: | MRP_ERO_RELEASE |
---|---|
Object Type: | TABLE |
Owner: | MRP |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_ID | NUMBER | msc_supplies transaction_id of planned external repair order | ||
REPAIR_SUPPLIER_ID | NUMBER | Repair supplier id | ||
REPAIR_SUPPLIER_ORG_ID | NUMBER | Repair supplier org id | ||
REPAIR_PROGRAM | NUMBER | Repair program corresponding to item in Planned external repair order | ||
BATCH_ID | NUMBER | Batch id for release; generated by src side sequence; | ||
DESTINATION_ORG_ID | NUMBER | Destination organization side | ||
SOURCE_ORG_ID | NUMBER | Source_org_id | ||
INVENTORY_ITEM_ID | NUMBER | Inventory_item_id | ||
PROMISE_DATE | DATE | ERO Promise Date | ||
QUANTITY | NUMBER | Quantity of repair order | ||
DEFECTIVE_ITEM_ID | NUMBER | Defective_item_id | ||
DEFECTIVE_ITEM_QTY | NUMBER | Defective_item_qty |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_ID
, REPAIR_SUPPLIER_ID
, REPAIR_SUPPLIER_ORG_ID
, REPAIR_PROGRAM
, BATCH_ID
, DESTINATION_ORG_ID
, SOURCE_ORG_ID
, INVENTORY_ITEM_ID
, PROMISE_DATE
, QUANTITY
, DEFECTIVE_ITEM_ID
, DEFECTIVE_ITEM_QTY
FROM MRP.MRP_ERO_RELEASE;
MRP.MRP_ERO_RELEASE does not reference any database object
MRP.MRP_ERO_RELEASE is referenced by following:
|
|
|