APPS.CSTPSISC SQL Statements

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

Line: 94

      INSERT INTO MTL_CST_TXN_COST_DETAILS (
        transaction_id,
        organization_id,
        inventory_item_id,
        cost_element_id,
        level_type,
        transaction_cost,
        new_average_cost,
        percentage_change,
        value_change,
        last_update_date,
        last_updated_by,
        creation_date,
        created_by,
        last_update_login,
        request_id,
        program_application_id,
        program_id,
        program_update_date
        )
      VALUES(
        i_txn_id,
        i_org_id,
        i_inv_item_id,
        1,		-- material
        1,		-- this level
        i_txn_cost,
        NULL,
        NULL,
        NULL,
        sysdate,
        i_user_id,
        sysdate,
        i_user_id,
        i_login_id,
        i_request_id,
        i_prog_appl_id,
        i_prog_id,
        sysdate);

Line: 143

      INSERT INTO MTL_CST_ACTUAL_COST_DETAILS (
	transaction_id,
	organization_id,
	layer_id,
	cost_element_id,
	level_type,
	transaction_action_id,
	last_update_date,
	last_updated_by,
	creation_date,
	created_by,
	last_update_login,
	request_id,
	program_application_id,
	program_id,
	program_update_date,
	inventory_item_id,
	actual_cost,
	prior_cost,
	new_cost,
	insertion_flag,
	variance_amount,
	user_entered)
      SELECT
	i_txn_id,
	i_org_id,
	-1,		-- layer_id = -1 for std.
	cost_element_id,
	level_type,
	i_txn_action_id,
	sysdate,
	i_user_id,
	sysdate,
	i_user_id,
	i_login_id,
	i_request_id,
	i_prog_appl_id,
	i_prog_id,
	sysdate,
	i_inv_item_id,
	SUM(DECODE(LEVEL_TYPE,2,DECODE(COST_ELEMENT_ID,1,ITEM_COST,
							2,ITEM_COST,
							3,ITEM_COST,
							4,ITEM_COST,
							5,ITEM_COST),
			      1,DECODE(COST_ELEMENT_ID,1,ITEM_COST,
							2,ITEM_COST,
							3,ITEM_COST,
							4,ITEM_COST,
							5,ITEM_COST))),
	NULL,
	NULL,
	'N',
	NULL,
	'N'
      FROM  CST_ITEM_COST_DETAILS CICD,
            MTL_PARAMETERS MP
      WHERE MP.organization_id = i_org_id
      AND   CICD.organization_id = MP.cost_organization_id
      AND   CICD.inventory_item_id = i_inv_item_id
      AND   CICD.cost_type_id = 1
      GROUP BY CICD.level_type, CICD.cost_element_id;

Line: 209

         only insert into MACS
      */
      l_earn_moh := 1;

Line: 232

      INSERT INTO mtl_actual_cost_subelement(
	transaction_id,
	organization_id,
	layer_id,
	cost_element_id,
	level_type,
	resource_id,
	last_update_date,
	last_updated_by,
	creation_date,
	created_by,
	last_update_login,
	request_id,
	program_application_id,
	program_id,
	program_update_date,
	actual_cost,
	user_entered)
      SELECT i_txn_id,
	i_org_id,
	-1,		-- layer_id = -1 for std.
	cost_element_id,
	level_type,
	resource_id,
	sysdate,
        i_user_id,
	sysdate,
	i_user_id,
   	i_login_id,
      	i_request_id,
      	i_prog_appl_id,
      	i_prog_id,
      	sysdate,
	item_cost,
	'N'
      FROM  CST_ITEM_COST_DETAILS CICD,
            MTL_PARAMETERS MP
      WHERE MP.organization_id = i_org_id
      AND   CICD.organization_id = MP.cost_organization_id
      AND   CICD.inventory_item_id = i_inv_item_id
      AND   CICD.cost_type_id = 1
      AND   CICD.level_type = 1
      AND   CICD.cost_element_id = 2;

Line: 283

	INSERT INTO MTL_CST_ACTUAL_COST_DETAILS (
	  transaction_id,
	  organization_id,
	  layer_id,
	  cost_element_id,
	  level_type,
	  transaction_action_id,
	  last_update_date,
	  last_updated_by,
	  creation_date,
	  created_by,
	  last_update_login,
	  request_id,
	  program_application_id,
	  program_id,
	  program_update_date,
	  inventory_item_id,
	  actual_cost,
	  prior_cost,
	  new_cost,
	  insertion_flag,
	  variance_amount,
	  user_entered
	)
	VALUES(
	  i_txn_id,
	  i_org_id,
	  -1,		-- layer_id = -1 for std.
	  1,		-- material
	  1,		-- this level
	  i_txn_action_id,
	  sysdate,
	  i_user_id,
	  sysdate,
	  i_user_id,
	  i_login_id,
	  i_request_id,
	  i_prog_appl_id,
	  i_prog_id,
	  sysdate,
	  i_inv_item_id,
	  i_txn_cost,
	  NULL,
	  NULL,
	  'N',
	  NULL,
	  'N');

Line: 340

	INSERT INTO MTL_CST_ACTUAL_COST_DETAILS (
	  transaction_id,
	  organization_id,
	  layer_id,
	  cost_element_id,
	  level_type,
	  transaction_action_id,
	  last_update_date,
	  last_updated_by,
	  creation_date,
	  created_by,
	  last_update_login,
	  request_id,
	  program_application_id,
	  program_id,
	  program_update_date,
	  inventory_item_id,
	  actual_cost,
	  prior_cost,
	  new_cost,
	  insertion_flag,
	  variance_amount,
	  user_entered
	)
	VALUES(
	  i_txn_id,
	  i_org_id,
	  -1,		-- layer_id = -1 for std.
	  1,		-- material
	  1,		-- this level
	  i_txn_action_id,
	  sysdate,
	  i_user_id,
	  sysdate,
	  i_user_id,
	  i_login_id,
	  i_request_id,
	  i_prog_appl_id,
	  i_prog_id,
	  sysdate,
	  i_inv_item_id,
	  i_actual_cost,
	  NULL,
	  NULL,
	  'N',
	  NULL,
	  'N');

Line: 391

      SELECT primary_quantity, organization_id, transfer_organization_id
      INTO l_txn_qty, l_org_id, l_txfr_org_id
      FROM mtl_material_transactions
      WHERE transaction_id = i_txn_id;

Line: 430

      FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inserting into MCACD... ');*/

Line: 435

	INSERT INTO MTL_CST_ACTUAL_COST_DETAILS (
	  transaction_id,
	  organization_id,
	  layer_id,
	  cost_element_id,
	  level_type,
	  transaction_action_id,
	  last_update_date,
	  last_updated_by,
	  creation_date,
	  created_by,
	  last_update_login,
	  request_id,
	  program_application_id,
	  program_id,
	  program_update_date,
	  inventory_item_id,
	  actual_cost,
	  prior_cost,
	  new_cost,
	  insertion_flag,
	  variance_amount,
	  user_entered)
	SELECT
	  i_txn_id,
	  i_org_id,
	  -1,		-- layer_id = -1 for std.
	  cost_element_id,
	  level_type,
	  i_txn_action_id,
	  sysdate,
	  i_user_id,
	  sysdate,
	  i_user_id,
	  i_login_id,
	  i_request_id,
	  i_prog_appl_id,
	  i_prog_id,
	  sysdate,
	  i_inv_item_id,
	  SUM(DECODE(LEVEL_TYPE,2,DECODE(COST_ELEMENT_ID,1,ITEM_COST,
							 2,ITEM_COST,
							 3,ITEM_COST,
							 4,ITEM_COST,
							 5,ITEM_COST),
				1,DECODE(COST_ELEMENT_ID,1,ITEM_COST,
							 2,ITEM_COST,
							 3,ITEM_COST,
							 4,ITEM_COST,
							 5,ITEM_COST))),
	  NULL,
	  NULL,
	  'N',
	  NULL,
	  'N'
	FROM  CST_ITEM_COST_DETAILS CICD,
              MTL_PARAMETERS MP
	WHERE MP.organization_id = i_org_id
	AND   CICD.organization_id = MP.cost_organization_id
        AND   CICD.inventory_item_id = i_inv_item_id
	AND   CICD.cost_type_id = 1
	GROUP BY CICD.level_type, CICD.cost_element_id;

Line: 499

	INSERT INTO MTL_CST_ACTUAL_COST_DETAILS (
			transaction_id,
			organization_id,
			layer_id,
			cost_element_id,
			level_type,
			transaction_action_id,
			last_update_date,
			last_updated_by,
			creation_date,
			created_by,
			last_update_login,
			request_id,
			program_application_id,
			program_id,
			program_update_date,
			inventory_item_id,
			actual_cost,
			prior_cost,
			new_cost,
			insertion_flag,
			variance_amount,
			user_entered)
			SELECT
			i_txn_id,
			i_org_id,
			-1,  -- layer_id = -1 for std.
			1,   -- hard coded to 1 for items having no cicd
			1,   -- hard coded to 1 for items having no cicd
			i_txn_action_id,
			sysdate,
			i_user_id,
			sysdate,
			i_user_id,
			i_login_id,
			i_request_id,
			i_prog_appl_id,
			i_prog_id,
			sysdate,
			i_inv_item_id,
			0,
			NULL,
			NULL,
			'N',
			NULL,
			'N'
			FROM  dual;

Line: 552

	INSERT INTO MTL_CST_ACTUAL_COST_DETAILS (
	  transaction_id,
	  organization_id,
	  layer_id,
	  cost_element_id,
	  level_type,
	  transaction_action_id,
	  last_update_date,
	  last_updated_by,
	  creation_date,
	  created_by,
	  last_update_login,
	  request_id,
	  program_application_id,
	  program_id,
	  program_update_date,
	  inventory_item_id,
	  actual_cost,
	  prior_cost,
	  new_cost,
	  insertion_flag,
	  variance_amount,
	  user_entered)
	SELECT
	  i_txn_id,
	  i_org_id,
	  -1,		-- layer_id = -1 for std.
	  cost_element_id,
	  level_type,
	  i_txn_action_id,
	  sysdate,
	  i_user_id,
	  sysdate,
	  i_user_id,
	  i_login_id,
	  i_request_id,
	  i_prog_appl_id,
	  i_prog_id,
	  sysdate,
	  i_inv_item_id,
	  0,
   	  NULL,
	  NULL,
	  'N',
	  NULL,
	  'N'
	FROM  CST_ITEM_COST_DETAILS CICD,
              MTL_PARAMETERS MP
	WHERE MP.organization_id = i_org_id
	AND   CICD.organization_id = MP.cost_organization_id
        AND   CICD.inventory_item_id = i_inv_item_id
	AND   CICD.cost_type_id = 1
	GROUP BY CICD.level_type, CICD.cost_element_id;

Line: 612

        FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inserting into MCACD for receiving org... ');

Line: 615

        INSERT INTO MTL_CST_ACTUAL_COST_DETAILS (
          transaction_id,
          organization_id,
          layer_id,
          cost_element_id,
          level_type,
          transaction_action_id,
          last_update_date,
          last_updated_by,
          creation_date,
          created_by,
          last_update_login,
          request_id,
          program_application_id,
          program_id,
          program_update_date,
          inventory_item_id,
          actual_cost,
          prior_cost,
          new_cost,
          insertion_flag,
          variance_amount,
          user_entered)
        SELECT
          i_txn_id,
          i_org_id,
          -1,           -- layer_id = -1 for std.
          cost_element_id,
          level_type,
          i_txn_action_id,
          sysdate,
          i_user_id,
          sysdate,
          i_user_id,
          i_login_id,
          i_request_id,
          i_prog_appl_id,
          i_prog_id,
          sysdate,
          i_inv_item_id,
          SUM(DECODE(LEVEL_TYPE,2,DECODE(COST_ELEMENT_ID,1,ITEM_COST,
                                                         2,ITEM_COST,
                                                         3,ITEM_COST,
                                                         4,ITEM_COST,
                                                         5,ITEM_COST),
                                1,DECODE(COST_ELEMENT_ID,1,ITEM_COST,
                                                         2,ITEM_COST,
                                                         3,ITEM_COST,
                                                         4,ITEM_COST,
                                                         5,ITEM_COST))),
          NULL,
          NULL,
          'N',
          NULL,
          'N'
        FROM  CST_ITEM_COST_DETAILS CICD,
              MTL_PARAMETERS MP
        WHERE MP.organization_id = i_org_id
        AND   CICD.organization_id = MP.cost_organization_id
        AND   CICD.inventory_item_id = i_inv_item_id
        AND   CICD.cost_type_id = 1
	AND   CICD.cost_element_id = 2
        GROUP BY CICD.level_type, CICD.cost_element_id;

Line: 685

          SELECT nvl(MMT.fob_point, MIP.fob_point)
          INTO l_fob_point
          FROM MTL_INTERORG_PARAMETERS MIP, MTL_MATERIAL_TRANSACTIONS MMT
          WHERE MIP.from_organization_id = l_org_id
          AND MIP.to_organization_id = l_txfr_org_id
          AND MMT.transaction_id = i_txn_id;

Line: 693

          SELECT nvl(MMT.fob_point, MIP.fob_point)
          INTO l_fob_point
          FROM MTL_INTERORG_PARAMETERS MIP, MTL_MATERIAL_TRANSACTIONS MMT
          WHERE MIP.from_organization_id = l_txfr_org_id
          AND MIP.to_organization_id = l_org_id
          AND MMT.transaction_id = i_txn_id;

Line: 726

         only insert into MACS
        */
       l_earn_moh := 1;

Line: 747

       FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inserting into MACS... ');

Line: 750

    	INSERT INTO mtl_actual_cost_subelement(
           transaction_id,
	   organization_id,
	   layer_id,
      	   cost_element_id,
	   level_type,
	   resource_id,
	   last_update_date,
	   last_updated_by,
	   creation_date,
	   created_by,
	   last_update_login,
	   request_id,
	   program_application_id,
	   program_id,
	   program_update_date,
	   actual_cost,
	   user_entered)
       SELECT i_txn_id,
	   i_org_id,
	   -1,		-- layer_id = -1 for std.
	   cost_element_id,
	   level_type,
	   resource_id,
	   sysdate,
           i_user_id,
	   sysdate,
	   i_user_id,
   	   i_login_id,
      	   i_request_id,
      	   i_prog_appl_id,
      	   i_prog_id,
      	   sysdate,
	   item_cost,
	   'N'
       FROM  CST_ITEM_COST_DETAILS CICD,
             MTL_PARAMETERS MP
       WHERE MP.organization_id = i_org_id
       AND   CICD.organization_id = MP.cost_organization_id
       AND   CICD.inventory_item_id = i_inv_item_id
       AND   CICD.cost_type_id = 1
       AND   CICD.level_type = 1
       AND   CICD.cost_element_id = 2;