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: APPS.CSP_SUP_DEM_SUB_V

Source

View Text - Preformatted


SELECT csdsm.inventory_item_id, msibk.concatenated_segments, msibk.description, csdsm.organization_id, csdsm.subinventory_code, csdsm.planning_parameters_id, msibk.primary_uom_code, csdsm.onhand_bad, csdsm.onhand_good, csdsm.intransit_move_orders, csdsm.purchase_orders, csdsm.sales_orders, csdsm.work_orders, csdsm.requisitions, csdsm.move_orders_in, csdsm.move_orders_out, csdsm.interorg_transf_in, csdsm.interorg_transf_out, csdsm.move_orders_in+csdsm.interorg_transf_in , csdsm.move_orders_out+csdsm.interorg_transf_out,nvl(cel.excess_quantity,0),am.creation_date from csp_sup_dem_sub_mv csdsm, mtl_system_items_b_kfv msibk, csp_excess_lists cel, (select last_refresh_date creation_date from all_mviews where mview_name = 'CSP_SUP_DEM_SUB_MV') am where csdsm.inventory_item_id = msibk.inventory_item_id and csdsm.organization_id = msibk.organization_id and csdsm.inventory_item_id = cel.inventory_item_id(+) and csdsm.organization_id = cel.organization_id(+) and nvl(csdsm.subinventory_code,'-') = nvl(cel.subinventory_code(+),'-')

View Text - HTML Formatted

SELECT CSDSM.INVENTORY_ITEM_ID
, MSIBK.CONCATENATED_SEGMENTS
, MSIBK.DESCRIPTION
, CSDSM.ORGANIZATION_ID
, CSDSM.SUBINVENTORY_CODE
, CSDSM.PLANNING_PARAMETERS_ID
, MSIBK.PRIMARY_UOM_CODE
, CSDSM.ONHAND_BAD
, CSDSM.ONHAND_GOOD
, CSDSM.INTRANSIT_MOVE_ORDERS
, CSDSM.PURCHASE_ORDERS
, CSDSM.SALES_ORDERS
, CSDSM.WORK_ORDERS
, CSDSM.REQUISITIONS
, CSDSM.MOVE_ORDERS_IN
, CSDSM.MOVE_ORDERS_OUT
, CSDSM.INTERORG_TRANSF_IN
, CSDSM.INTERORG_TRANSF_OUT
, CSDSM.MOVE_ORDERS_IN+CSDSM.INTERORG_TRANSF_IN
, CSDSM.MOVE_ORDERS_OUT+CSDSM.INTERORG_TRANSF_OUT
, NVL(CEL.EXCESS_QUANTITY
, 0)
, AM.CREATION_DATE
FROM CSP_SUP_DEM_SUB_MV CSDSM
, MTL_SYSTEM_ITEMS_B_KFV MSIBK
, CSP_EXCESS_LISTS CEL
, (SELECT LAST_REFRESH_DATE CREATION_DATE
FROM ALL_MVIEWS
WHERE MVIEW_NAME = 'CSP_SUP_DEM_SUB_MV') AM
WHERE CSDSM.INVENTORY_ITEM_ID = MSIBK.INVENTORY_ITEM_ID
AND CSDSM.ORGANIZATION_ID = MSIBK.ORGANIZATION_ID
AND CSDSM.INVENTORY_ITEM_ID = CEL.INVENTORY_ITEM_ID(+)
AND CSDSM.ORGANIZATION_ID = CEL.ORGANIZATION_ID(+)
AND NVL(CSDSM.SUBINVENTORY_CODE
, '-') = NVL(CEL.SUBINVENTORY_CODE(+)
, '-')