[Home] [Help] [Dependency Information]
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
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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;
MRP.MRP_ORG_TRANSFER_RELEASE does not reference any database object
MRP.MRP_ORG_TRANSFER_RELEASE is referenced by following:
|
|
|