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

TABLE: MRP.MRP_IRO_RELEASE

Object Details
Object Name: MRP_IRO_RELEASE
Object Type: TABLE
Owner: MRP
Subobject Name:
Status: VALID


MRP_IRO_RELEASE is an Interface table used for releasing internal Repair Orders


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER

msc_supplies transaction_id of planned repair order (DO)
QUANTITY NUMBER

Quantity of repair order
IN_REQ_TRANSACTION_ID NUMBER

msc_supplies transaction_id of IR for moving defective to depot org (DO)
OUT_REQ_TRANSACTION_ID NUMBER

msc_supplies transaction_id of IR for moving good part out of depot org (UWH)
BATCH_ID NUMBER

Batch id for release; generated by src side sequence; equal to corresponding batch_id in mrp_org_transfer_release for respective tr ordrs
INVENTORY_ITEM_ID NUMBER

Item id for RO
UOM_CODE VARCHAR2 (3)
Uom code of RO
ORGANIZATION_ID NUMBER

Depot Organization id
PROMISE_DATE DATE

RO Promise Date
IN_REQ_QUANTITY NUMBER

Quantity of defective inbound shipment
OUT_REQ_QUANTITY NUMBER

Quantity of usable item shipped out of depo org
LOAD_TYPE NUMBER

Type of release that is happening
DELIVER_TO_LOCATION_ID NUMBER

Location Identifier of which the items are delivered
SRC_ORGANIZATION_ID NUMBER

Organization Identifier of the Source
Query Text

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


SELECT TRANSACTION_ID
,      QUANTITY
,      IN_REQ_TRANSACTION_ID
,      OUT_REQ_TRANSACTION_ID
,      BATCH_ID
,      INVENTORY_ITEM_ID
,      UOM_CODE
,      ORGANIZATION_ID
,      PROMISE_DATE
,      IN_REQ_QUANTITY
,      OUT_REQ_QUANTITY
,      LOAD_TYPE
,      DELIVER_TO_LOCATION_ID
,      SRC_ORGANIZATION_ID
FROM MRP.MRP_IRO_RELEASE;

Dependencies

[top of page]

MRP.MRP_IRO_RELEASE does not reference any database object

MRP.MRP_IRO_RELEASE is referenced by following:

SchemaAPPS
SynonymMRP_IRO_RELEASE