VIEW: APPS.CSP_SUP_DEM_PN_V

Source

View Text - Preformatted

SELECT csdpm.node_name, csdpm.planning_parameters_id, nvl(csdpm.parent_node_id,-1) parent_node_id, msiv.inventory_item_id, msiv.concatenated_segments, msiv.description, msiv.primary_uom_code, csdpm.onhand_good, csdpm.onhand_bad, 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,csdpm.excess_quantity,am.creation_date from csp_sup_dem_pn_mv csdpm, mtl_system_items_b_kfv msiv , (select last_refresh_date creation_date from all_mviews where mview_name = 'CSP_SUP_DEM_PN_MV') am where msiv.inventory_item_id = csdpm.inventory_item_id and msiv.organization_id = csdpm.organization_id

View Text - HTML Formatted

SELECT CSDPM.NODE_NAME
, CSDPM.PLANNING_PARAMETERS_ID
, NVL(CSDPM.PARENT_NODE_ID
, -1) PARENT_NODE_ID
, MSIV.INVENTORY_ITEM_ID
, MSIV.CONCATENATED_SEGMENTS
, MSIV.DESCRIPTION
, MSIV.PRIMARY_UOM_CODE
, CSDPM.ONHAND_GOOD
, CSDPM.ONHAND_BAD
, 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
, CSDPM.EXCESS_QUANTITY
, AM.CREATION_DATE
FROM CSP_SUP_DEM_PN_MV CSDPM
, MTL_SYSTEM_ITEMS_B_KFV MSIV
, (SELECT LAST_REFRESH_DATE CREATION_DATE
FROM ALL_MVIEWS
WHERE MVIEW_NAME = 'CSP_SUP_DEM_PN_MV') AM
WHERE MSIV.INVENTORY_ITEM_ID = CSDPM.INVENTORY_ITEM_ID
AND MSIV.ORGANIZATION_ID = CSDPM.ORGANIZATION_ID