DBA Data[Home] [Help]

APPS.INV_WWACST SQL Statements

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

Line: 172

	  SELECT costing_group_id
	    INTO l_xfr_cost_group_id
	    FROM mrp_project_parameters
	    WHERE organization_id = p_FM_ORG_ID
	    AND project_id = p_SOURCE_PROJECT_ID ;
Line: 184

		SELECT default_cost_group_id INTO l_xfr_cost_group_id from
		  mtl_parameters WHERE organization_id = p_fm_org_id;
Line: 201

	 SELECT costing_group_id
	   INTO l_cost_group_id
	   FROM mrp_project_parameters
	   WHERE organization_id = p_FM_ORG_ID
	   AND project_id = p_FM_PROJECT_ID ;
Line: 213

	       SELECT default_cost_group_id INTO l_cost_group_id from
		 mtl_parameters WHERE organization_id = p_fm_org_id;
Line: 231

	 SELECT costing_group_id
	   INTO l_xfr_cost_group_id
	   FROM mrp_project_parameters
	   WHERE organization_id = x_to_org_id
	   AND project_id = p_TO_PROJECT_ID ;
Line: 249

	    SELECT default_cost_group_id INTO l_xfr_cost_group_id from
	      mtl_parameters WHERE organization_id =  x_to_org_id;
Line: 268

	    SELECT NVL(type_class,2)
	      INTO v_type_class
	      FROM mtl_transaction_types
	      WHERE transaction_type_id = p_TRX_TYPE_ID ;
Line: 363

   cost_det_new_insert
*/
if ( ((v_txn_src_type_id IN (3,6,13)) OR (v_txn_src_type_id > 100) ) AND
   (v_txn_action_id IN (1,27)) ) then

  CSTPACIT.cost_det_new_insert(
	V_TRANSACTION_ID,
	V_TXN_ACTION_ID,
	V_ORG_ID,
	V_ITEM_ID,
	V_COST_GROUP_ID,
	V_TXN_COST,
	V_NEW_AVG_COST,
	V_PER_CHANGE,
	V_VAL_CHANGE,
	V_MAT_ACCNT,
	V_MAT_OVHD_ACCNT,
	V_RES_ACCNT,
	V_OSP_ACCNT,
	V_OVHD_ACCNT,
	V_USER_ID,
	V_LOGIN_ID,
	V_REQUEST_ID,
	V_PROG_APPL_ID,
	V_PROG_ID,
	V_ERR_NUM,
	V_ERR_CODE,
	V_ERR_MESG);
Line: 394

   * not insert a row if we are doing a intrasnsit receipt or
   * intransit shipment. Also not to insert if it is cost
   * update transaction. (Fix bug 842532)
  */
  /*Bug 8760375,If transaction is a subinv transfer transaction,should NOT insert a record into MCTCD.*/
  if ( v_txn_action_id NOT IN (12, 21, 24, 2)) then

      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 (
      v_transaction_id,
      v_org_id,
      v_item_id,
      1,			/* Hard coded to This level Material */
      1,
      v_txn_cost,
      v_new_avg_cost,
      v_per_change,
      v_val_change,
      sysdate,
      v_user_id,
      sysdate,
      v_user_id,
      v_login_id,
      v_request_id,
      v_prog_appl_id,
      v_prog_id,
      sysdate);