APPS.WMS_COSTGROUPENGINE_PVT SQL Statements

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

Line: 171

	SELECT organization_id
	      ,to_subinventory_code
	      ,transaction_action_id
	      ,to_organization_id
	FROM wms_cost_groups_input_v
	WHERE line_id = p_line_id; */

Line: 179

     SELECT  MTRL.ORGANIZATION_ID ORGANIZATION_ID,
 	 MTRL.TO_SUBINVENTORY_CODE TO_SUBINVENTORY_CODE,
     to_number(NULL) transaction_action_id,	     -- swapped the third and fourth parameter for bug 6761233
	 MTRL.ORGANIZATION_ID TO_ORGANIZATION_ID
	FROM MTL_TXN_REQUEST_LINES MTRL
	WHERE mtrl.line_id=p_line_id;

Line: 187

     SELECT
	  DECODE(mmtt.transaction_action_id, 3, mmtt.organization_id,
                                             21, DECODE(mip.fob_point, 1, transfer_organization, organization_id)
                                               , organization_id)   ORGANIZATION_ID,
	  DECODE(transaction_action_id, 1, NULL,
                                        2, transfer_subinventory,
                                        3, transfer_subinventory,
                                       21, NULL,
                                       28, transfer_subinventory,
                                       29, subinventory_code,
                                       32, NULL,
                                       34, NULL
                                         , subinventory_code) to_subinventory_code,
        mmtt.transaction_action_id  transaction_action_id,		-- swapped the third and fourth parameter for bug 6761233
         DECODE(transaction_action_id, 3, transfer_organization,
                                       21, transfer_organization,
                                        organization_id) TO_ORGANIZATION_ID
     FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt,
          MTL_INTERORG_PARAMETERS mip
       WHERE mip.from_organization_id (+)   = mmtt.organization_id
       AND mip.to_organization_id (+)       = mmtt.transfer_organization
       AND mmtt.transaction_temp_id = p_line_id;

Line: 211

	SELECT fob_point
	  FROM MTL_INTERORG_PARAMETERS
	 WHERE from_organization_id = l_organization_id/*changed from l_source_organization_id for 3224420*/
	   AND to_organization_id = l_transfer_organization_id;

Line: 218

	SELECT count(object_name)
	FROM user_objects
	WHERE object_name = l_package_name;

Line: 224

       SELECT type_hdr_id
         FROM wms_rules_b
        WHERE rule_id = l_rule_id;

Line: 230

	SELECT default_cost_group_id
	  FROM mtl_secondary_inventories
	 WHERE secondary_inventory_name = l_to_subinventory_code
	   AND organization_id = l_organization_id;

Line: 238

	SELECT default_cost_group_id
	  FROM mtl_parameters
	 WHERE organization_id = l_organization_id;

Line: 302

         log_event(l_api_name, 'mmtt_line', 'Update a transaction with ' ||
  	        'transaction temp id: ' || p_line_id);

Line: 307

         log_event(l_api_name, 'mmtt_line', 'Update a move order with ' ||
		'move order line id: ' || p_line_id);

Line: 758

           UPDATE mtl_material_transactions_temp mmtt
              SET mmtt.transfer_cost_group_id = l_cost_group_id
            WHERE mmtt.transaction_temp_id = p_line_id;

Line: 764

           UPDATE mtl_material_transactions_temp mmtt
              SET mmtt.cost_group_id = l_cost_group_id
            WHERE mmtt.transaction_temp_id = p_line_id;

Line: 771

        UPDATE mtl_txn_request_lines mtrl
           SET mtrl.to_cost_group_id = l_cost_group_id
         WHERE mtrl.line_id = p_line_id;