VIEW: APPS.CSP_CURR_SUP_DEM_SUMS_V2

Source

View Text - Preformatted

SELECT csdsv.subinventory_code, csdsv.planning_parameters_id, csdsv.organization_id, csdsv.subinventory_code, to_number(null), csdsv.inventory_item_id, csdsv.item_number, csdsv.item_description, csdsv.primary_uom_code, csdsv.onhand_good, csdsv.onhand_bad, csdsv.intransit_move_orders, csdsv.purchase_orders, csdsv.sales_orders, csdsv.work_orders, csdsv.requisitions, csdsv.move_orders_in, csdsv.move_orders_out, csdsv.interorg_transf_in, csdsv.interorg_transf_out, csdsv.move_orders_in+csdsv.interorg_transf_in transfer_in, csdsv.move_orders_out+csdsv.interorg_transf_out transfer_out, csdsv.creation_date, csdsv.excess_quantity from csp_sup_dem_sub_v csdsv union all SELECT csdsv.node_name, csdsv.planning_parameters_id, to_number(null), to_char(null), csdsv.parent_node_id, csdsv.inventory_item_id, csdsv.item_number, csdsv.item_description, csdsv.primary_uom_code, csdsv.onhand_good, csdsv.onhand_bad, csdsv.intransit_move_orders, csdsv.purchase_orders, csdsv.sales_orders, csdsv.work_orders, csdsv.requisitions, csdsv.move_orders_in, csdsv.move_orders_out, csdsv.interorg_transf_in, csdsv.interorg_transf_out, csdsv.move_orders_in+csdsv.interorg_transf_in transfer_in, csdsv.move_orders_out+csdsv.interorg_transf_out transfer_out, csdsv.creation_date, csdsv.excess_quantity from csp_sup_dem_pn_v csdsv

View Text - HTML Formatted

SELECT CSDSV.SUBINVENTORY_CODE
, CSDSV.PLANNING_PARAMETERS_ID
, CSDSV.ORGANIZATION_ID
, CSDSV.SUBINVENTORY_CODE
, TO_NUMBER(NULL)
, CSDSV.INVENTORY_ITEM_ID
, CSDSV.ITEM_NUMBER
, CSDSV.ITEM_DESCRIPTION
, CSDSV.PRIMARY_UOM_CODE
, CSDSV.ONHAND_GOOD
, CSDSV.ONHAND_BAD
, CSDSV.INTRANSIT_MOVE_ORDERS
, CSDSV.PURCHASE_ORDERS
, CSDSV.SALES_ORDERS
, CSDSV.WORK_ORDERS
, CSDSV.REQUISITIONS
, CSDSV.MOVE_ORDERS_IN
, CSDSV.MOVE_ORDERS_OUT
, CSDSV.INTERORG_TRANSF_IN
, CSDSV.INTERORG_TRANSF_OUT
, CSDSV.MOVE_ORDERS_IN+CSDSV.INTERORG_TRANSF_IN TRANSFER_IN
, CSDSV.MOVE_ORDERS_OUT+CSDSV.INTERORG_TRANSF_OUT TRANSFER_OUT
, CSDSV.CREATION_DATE
, CSDSV.EXCESS_QUANTITY
FROM CSP_SUP_DEM_SUB_V CSDSV UNION ALL SELECT CSDSV.NODE_NAME
, CSDSV.PLANNING_PARAMETERS_ID
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, CSDSV.PARENT_NODE_ID
, CSDSV.INVENTORY_ITEM_ID
, CSDSV.ITEM_NUMBER
, CSDSV.ITEM_DESCRIPTION
, CSDSV.PRIMARY_UOM_CODE
, CSDSV.ONHAND_GOOD
, CSDSV.ONHAND_BAD
, CSDSV.INTRANSIT_MOVE_ORDERS
, CSDSV.PURCHASE_ORDERS
, CSDSV.SALES_ORDERS
, CSDSV.WORK_ORDERS
, CSDSV.REQUISITIONS
, CSDSV.MOVE_ORDERS_IN
, CSDSV.MOVE_ORDERS_OUT
, CSDSV.INTERORG_TRANSF_IN
, CSDSV.INTERORG_TRANSF_OUT
, CSDSV.MOVE_ORDERS_IN+CSDSV.INTERORG_TRANSF_IN TRANSFER_IN
, CSDSV.MOVE_ORDERS_OUT+CSDSV.INTERORG_TRANSF_OUT TRANSFER_OUT
, CSDSV.CREATION_DATE
, CSDSV.EXCESS_QUANTITY
FROM CSP_SUP_DEM_PN_V CSDSV