VIEW: APPS.CSP_SUP_DEM_PL_V

Source

View Text - Preformatted

SELECT csdpm.inventory_item_id, msibk.concatenated_segments, msibk.description, csdpm.parts_loop_id, msibk.primary_uom_code, csdpm.onhand_bad, csdpm.onhand_good, csdpm.intransit_move_orders, csdpm.purchase_orders, csdpm.sales_orders, csdpm.work_orders, csdpm.requisitions, csdpm.move_orders_in, csdpm.move_orders_out, csdpm.interorg_transf_in, csdpm.interorg_transf_out, csdpm.move_orders_in+csdpm.interorg_transf_in transfer_in, csdpm.move_orders_out+csdpm.interorg_transf_out transfer_out , am.creation_date from csp_sup_dem_pls csdpm, mtl_system_items_b_kfv msibk, (select sysdate creation_date from dual) am where csdpm.inventory_item_id = msibk.inventory_item_id and csdpm.organization_id = msibk.organization_id

View Text - HTML Formatted

SELECT CSDPM.INVENTORY_ITEM_ID
, MSIBK.CONCATENATED_SEGMENTS
, MSIBK.DESCRIPTION
, CSDPM.PARTS_LOOP_ID
, MSIBK.PRIMARY_UOM_CODE
, CSDPM.ONHAND_BAD
, CSDPM.ONHAND_GOOD
, CSDPM.INTRANSIT_MOVE_ORDERS
, CSDPM.PURCHASE_ORDERS
, CSDPM.SALES_ORDERS
, CSDPM.WORK_ORDERS
, CSDPM.REQUISITIONS
, CSDPM.MOVE_ORDERS_IN
, CSDPM.MOVE_ORDERS_OUT
, CSDPM.INTERORG_TRANSF_IN
, CSDPM.INTERORG_TRANSF_OUT
, CSDPM.MOVE_ORDERS_IN+CSDPM.INTERORG_TRANSF_IN TRANSFER_IN
, CSDPM.MOVE_ORDERS_OUT+CSDPM.INTERORG_TRANSF_OUT TRANSFER_OUT
, AM.CREATION_DATE
FROM CSP_SUP_DEM_PLS CSDPM
, MTL_SYSTEM_ITEMS_B_KFV MSIBK
, (SELECT SYSDATE CREATION_DATE
FROM DUAL) AM
WHERE CSDPM.INVENTORY_ITEM_ID = MSIBK.INVENTORY_ITEM_ID
AND CSDPM.ORGANIZATION_ID = MSIBK.ORGANIZATION_ID