DBA Data[Home] [Help]

APPS.INV_MWB_LOT_TREE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 29

      ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

         IF inv_mwb_globals.g_serial_from IS NOT NULL OR
            inv_mwb_globals.g_serial_to IS NOT NULL OR
            inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
            OR inv_mwb_globals.g_serial_attr_query IS NOT NULL              -- Bug 6429880
            OR inv_mwb_globals.g_unit_number IS NOT NULL                    -- Bug 9365452
         THEN
            make_common_queries('MSN_QUERY');
Line: 70

      ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

         IF inv_mwb_globals.g_serial_from IS NOT NULL OR
            inv_mwb_globals.g_serial_to IS NOT NULL
            OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
            OR inv_mwb_globals.g_serial_attr_query IS NOT NULL              -- Bug 6429880
            OR inv_mwb_globals.g_unit_number IS NOT NULL                    -- Bug 9365452
         THEN
            make_common_queries('MSN_QUERY');
Line: 79

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
               'msn.lot_number';
Line: 92

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
               'moqd.lot_number';
Line: 135

      ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

         IF inv_mwb_globals.g_serial_from IS NOT NULL OR
            inv_mwb_globals.g_serial_to IS NOT NULL
            OR inv_mwb_globals.g_status_id IS NOT NULL -- Bug 6060233
            OR inv_mwb_globals.g_serial_attr_query IS NOT NULL              -- Bug 6429880
            OR inv_mwb_globals.g_unit_number IS NOT NULL                    -- Bug 9365452
         THEN
            make_common_queries('MSN_QUERY');
Line: 144

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
               'msn.lot_number';
Line: 161

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
               'moqd.lot_number';
Line: 223

      ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

         SELECT revision_qty_control_code,
                serial_number_control_code
         INTO   l_rev_control,
                l_serial_control
         FROM   mtl_system_items
         WHERE  organization_id = inv_mwb_globals.g_tree_organization_id
         AND    inventory_item_id = inv_mwb_globals.g_tree_item_id;
Line: 235

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
               'msn.lot_number';
Line: 260

               inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
                  'msn.lot_number';
Line: 263

                  inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
                     'msn.revision';
Line: 289

               inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
                  'moqd.lot_number';
Line: 292

                  inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
                     'moqd.revision';
Line: 361

      ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

         SELECT serial_number_control_code
         INTO   l_serial_control
         FROM   mtl_system_items
         WHERE  organization_id = inv_mwb_globals.g_tree_organization_id
         AND    inventory_item_id = inv_mwb_globals.g_tree_item_id;
Line: 371

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
               'msn.lot_number';
Line: 373

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
               'msn.serial_number';
Line: 375

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
               'msn.revision';
Line: 397

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
               'moqd.lot_number';
Line: 399

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
               'moqd.revision';
Line: 466

      IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

         SELECT revision_qty_control_code
         INTO   l_rev_control
         FROM   mtl_system_items
         WHERE  organization_id = inv_mwb_globals.g_tree_organization_id
         AND    inventory_item_id = inv_mwb_globals.g_tree_item_id;
Line: 475

         inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
            'msn.lot_number';
Line: 477

         inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
            'msn.serial_number';
Line: 480

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
                    'msn.revision';
Line: 539

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
               'msn.inventory_item_id';
Line: 542

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
               'msn.current_organization_id';
Line: 545

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
               '''Ea''';
Line: 548

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value := 1;
Line: 550

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
               'DECODE(msn.lpn_id, NULL, 0,1)';
Line: 553

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
               'DECODE(msn.lpn_id, NULL, 1,0)';
Line: 556

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=
               'NULL';
Line: 559

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=
               'NULL';
Line: 562

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
               'NULL';
Line: 565

             inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
                'msn.serial_number';
Line: 574

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
               'moqd.inventory_item_id';
Line: 577

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
               'moqd.organization_id';
Line: 583

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
               'SUM(moqd.primary_transaction_quantity)';
Line: 586

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
               'SUM(DECODE(moqd.containerized_flag, 1, moqd.primary_transaction_quantity, 0))';
Line: 589

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
               'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.primary_transaction_quantity))';
Line: 592

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=
               'moqd.secondary_uom_code';
Line: 595

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_ONHAND).column_value :=
               'SUM(moqd.secondary_transaction_quantity)';
Line: 598

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=
               'SUM(DECODE(moqd.containerized_flag, 1, moqd.secondary_transaction_quantity, 0))';
Line: 601

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
               'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.secondary_transaction_quantity))';
Line: 613

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
               'msn.inventory_item_id';
Line: 615

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
               'msn.current_organization_id';
Line: 617

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
               '''Ea''';
Line: 619

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
                                    'count(1)';
Line: 621

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
                                    'sum(decode(msn.lpn_id,NULL,0, 1))';
Line: 623

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
                                    'sum(decode(msn.lpn_id,NULL,1, 0))';
Line: 653

      OR inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

         CASE inv_mwb_globals.g_tree_node_type

            WHEN 'APPTREE_OBJECT_TRUNK' THEN
               root_node_event (
                        x_node_value
                      , x_node_tbl
                      , x_tbl_index
                      );