[Home] [Help] [Dependency Information]
Object Name: | MRP_ORG_TRANSFER_RELEASE# |
---|---|
Object Type: | VIEW |
Owner: | MRP |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | |||
ITEM_ID | NUMBER | |||
SRC_ORGANIZATION_ID | NUMBER | |||
SR_INSTANCE_ID | NUMBER | |||
TO_ORGANIZATION_ID | NUMBER | |||
TO_SR_INSTANCE_ID | NUMBER | |||
QUANTITY | NUMBER | |||
NEED_BY_DATE | DATE | |||
SHIP_DATE | DATE | |||
DELIVER_TO_LOCATION_ID | NUMBER | |||
DELIVER_TO_REQUESTOR_ID | NUMBER | |||
PREPARER_ID | NUMBER | |||
UOM_CODE | VARCHAR2 | (30) | ||
CHARGE_ACCOUNT_ID | NUMBER | |||
GROUP_CODE | VARCHAR2 | (30) | ||
ITEM_REVISION | NUMBER | |||
TO_OPERATING_UNIT | NUMBER | |||
SRC_OPERATING_UNIT | NUMBER | |||
SALES_ORDER_LINE_ID | NUMBER | |||
SALES_ORDER_NUMBER | NUMBER | |||
SUGGESTED_VENDOR_ID | NUMBER | |||
SUGGESTED_VENDOR_SITE | VARCHAR2 | (30) | ||
PROJECT_ID | NUMBER | |||
TASK_ID | NUMBER | |||
END_ITEM_NUMBER | VARCHAR2 | (30) | ||
LOAD_TYPE | NUMBER | |||
FIRM_DEMAND_FLAG | VARCHAR2 | (1) | ||
SHIP_METHOD | VARCHAR2 | (80) | ||
TRANSACTION_ID | NUMBER | |||
EARLIEST_SHIP_DATE | DATE | |||
PLAN_TYPE | NUMBER | |||
PART_CONDITION | VARCHAR2 | (240) |
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#;
|
|
|