eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: MRP.MRP_ORG_TRANSFER_RELEASE#

Source

View Text - Preformatted


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

View Text - HTML Formatted

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