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

TABLE: MRP.MRP_ORG_TRANSFER_RELEASE

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


This interface table contains the requests to create or modify Internal Requisitions/Internal Sales Orders


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

Identifier for api call
ITEM_ID NUMBER

Source item id
SRC_ORGANIZATION_ID NUMBER

Source Organization id
SR_INSTANCE_ID NUMBER

Source org instance id
TO_ORGANIZATION_ID NUMBER

Destination Organization id
TO_SR_INSTANCE_ID NUMBER

Destination org instance id. Currently, should be same as sr_instance_id
QUANTITY NUMBER

Quantity
NEED_BY_DATE DATE

Need by arrival date
SHIP_DATE DATE

Ship date
DELIVER_TO_LOCATION_ID NUMBER

Deliver to location id
DELIVER_TO_REQUESTOR_ID NUMBER

Requestor id
PREPARER_ID NUMBER

Requestor id
UOM_CODE VARCHAR2 (30)
Uom code
CHARGE_ACCOUNT_ID NUMBER

Charge account id
GROUP_CODE VARCHAR2 (30)
Group code used to group multiple rows into a singe requisition
ITEM_REVISION NUMBER

Item revision
TO_OPERATING_UNIT NUMBER

Destination operating unit
SRC_OPERATING_UNIT NUMBER

Source operating unit
SALES_ORDER_LINE_ID NUMBER

Sales order line identifier
SALES_ORDER_NUMBER NUMBER

Sales order number
SUGGESTED_VENDOR_ID NUMBER

Suggested vendor identifier
SUGGESTED_VENDOR_SITE VARCHAR2 (30)
Suggested vendor site
PROJECT_ID NUMBER

Project identifier
TASK_ID NUMBER

Task identifier
END_ITEM_NUMBER VARCHAR2 (30)
End item number
LOAD_TYPE NUMBER

Load type
FIRM_DEMAND_FLAG VARCHAR2 (1)
Firm demand flag
SHIP_METHOD VARCHAR2 (80)
Ship method
TRANSACTION_ID NUMBER

Transaction id of msc_supplies
EARLIEST_SHIP_DATE DATE

Earliest Ship Date
PLAN_TYPE NUMBER

Plan Type for the plan which is releasing the order
PART_CONDITION VARCHAR2 (240)
ITEM PART CONDITION
Query Text

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


SELECT BATCH_ID
,      ITEM_ID
,      SRC_ORGANIZATION_ID
,      SR_INSTANCE_ID
,      TO_ORGANIZATION_ID
,      TO_SR_INSTANCE_ID
,      QUANTITY
,      NEED_BY_DATE
,      SHIP_DATE
,      DELIVER_TO_LOCATION_ID
,      DELIVER_TO_REQUESTOR_ID
,      PREPARER_ID
,      UOM_CODE
,      CHARGE_ACCOUNT_ID
,      GROUP_CODE
,      ITEM_REVISION
,      TO_OPERATING_UNIT
,      SRC_OPERATING_UNIT
,      SALES_ORDER_LINE_ID
,      SALES_ORDER_NUMBER
,      SUGGESTED_VENDOR_ID
,      SUGGESTED_VENDOR_SITE
,      PROJECT_ID
,      TASK_ID
,      END_ITEM_NUMBER
,      LOAD_TYPE
,      FIRM_DEMAND_FLAG
,      SHIP_METHOD
,      TRANSACTION_ID
,      EARLIEST_SHIP_DATE
,      PLAN_TYPE
,      PART_CONDITION
FROM MRP.MRP_ORG_TRANSFER_RELEASE;

Dependencies

[top of page]

MRP.MRP_ORG_TRANSFER_RELEASE does not reference any database object

MRP.MRP_ORG_TRANSFER_RELEASE is referenced by following:

SchemaMRP
ViewMRP_ORG_TRANSFER_RELEASE#