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: MSC.MSC_ALLOCATION_DETAILS#

Source

View Text - Preformatted


select PLAN_ID PLAN_ID, SR_INSTANCE_ID SR_INSTANCE_ID, TO_SR_INSTANCE_ID TO_SR_INSTANCE_ID, ORGANIZATION_ID ORGANIZATION_ID, TO_ORGANIZATION_ID TO_ORGANIZATION_ID, ITEM_ID ITEM_ID, PRIORITY PRIORITY, TO_ORG_SEQ_ID TO_ORG_SEQ_ID, ALLOC_BKT_ID ALLOC_BKT_ID, DEMAND_QTY DEMAND_QTY, ALLOCATED_QTY ALLOCATED_QTY, PRI_SUPPLY_QTY PRI_SUPPLY_QTY, PRI_DEMAND_QTY PRI_DEMAND_QTY, TOTAL_SUPPLY_QTY TOTAL_SUPPLY_QTY, HIGHER_PRI_DEMAND_QTY HIGHER_PRI_DEMAND_QTY, HIGHER_PRI_ALLOCATED_QTY HIGHER_PRI_ALLOCATED_QTY, ALLOC_RULE_ID ALLOC_RULE_ID, FIXED_LOT_MULTIPLIER FIXED_LOT_MULTIPLIER, FIRM_FLAG FIRM_FLAG, FIRM_CARRY_FWD_BKTS FIRM_CARRY_FWD_BKTS, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATED_BY LAST_UPDATED_BY, SUPPLIER_ID SUPPLIER_ID, SUPPLIER_SITE_ID SUPPLIER_SITE_ID, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_SITE_ID CUSTOMER_SITE_ID, DEMAND_CLASS DEMAND_CLASS, ASSEMBLY_ITEM_ID ASSEMBLY_ITEM_ID, SUMMARY_FLAG SUMMARY_FLAG from "MSC"."MSC_ALLOCATION_DETAILS"

View Text - HTML Formatted

SELECT PLAN_ID PLAN_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, TO_SR_INSTANCE_ID TO_SR_INSTANCE_ID
, ORGANIZATION_ID ORGANIZATION_ID
, TO_ORGANIZATION_ID TO_ORGANIZATION_ID
, ITEM_ID ITEM_ID
, PRIORITY PRIORITY
, TO_ORG_SEQ_ID TO_ORG_SEQ_ID
, ALLOC_BKT_ID ALLOC_BKT_ID
, DEMAND_QTY DEMAND_QTY
, ALLOCATED_QTY ALLOCATED_QTY
, PRI_SUPPLY_QTY PRI_SUPPLY_QTY
, PRI_DEMAND_QTY PRI_DEMAND_QTY
, TOTAL_SUPPLY_QTY TOTAL_SUPPLY_QTY
, HIGHER_PRI_DEMAND_QTY HIGHER_PRI_DEMAND_QTY
, HIGHER_PRI_ALLOCATED_QTY HIGHER_PRI_ALLOCATED_QTY
, ALLOC_RULE_ID ALLOC_RULE_ID
, FIXED_LOT_MULTIPLIER FIXED_LOT_MULTIPLIER
, FIRM_FLAG FIRM_FLAG
, FIRM_CARRY_FWD_BKTS FIRM_CARRY_FWD_BKTS
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATED_BY LAST_UPDATED_BY
, SUPPLIER_ID SUPPLIER_ID
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_SITE_ID CUSTOMER_SITE_ID
, DEMAND_CLASS DEMAND_CLASS
, ASSEMBLY_ITEM_ID ASSEMBLY_ITEM_ID
, SUMMARY_FLAG SUMMARY_FLAG
FROM "MSC"."MSC_ALLOCATION_DETAILS"