APPS.CSTPACWP SQL Statements

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

Line: 73

	select
	 inventory_item_id,
	 organization_id,
	 transaction_date,
	 transaction_action_id,
         transaction_source_type_id,
	 primary_quantity,
	 transaction_source_id,
	 operation_seq_num,
	 nvl(final_completion_flag,'N'),
	 acct_period_id
 	into
	 l_inv_item_id,
	 l_org_id,
	 l_txn_date,
	 l_action_id,
         l_src_type_id,
	 l_txn_qty,
	 l_wip_entity_id,
	 l_op_seq_num,
	 l_final_comp_flag,
	 l_period_id
	from mtl_material_transactions
	where
	 transaction_id=l_trx_id;

Line: 355

	| therefore deliberately refrain from inserting a
	| cost row. For completions, assembly returns and
	| scrap transactions however, in the respective
	| packages, we do not insert  row if the cost is zero.
	| To prevent such transactions from being processed at
	| current average cost, we need to insert a dummy
 	| TL materil row into the cost table with zero cost.
	|------------------------------------------------------*/



	stmt_num := 25;

Line: 368

	select count(*)
	into l_mtl_txn_exists
	from
	mtl_cst_txn_cost_details
	where
	transaction_id = l_trx_id;

Line: 381

        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
        (l_trx_id,
         l_org_id,
         l_inv_item_id,
         1,
         1,
         0,
         NULL,
         NULL,
         NULL,
         SYSDATE,
         l_user_id,
         SYSDATE,
         l_user_id,
         l_login_id,
         l_request_id,
         l_prog_app_id,
         l_prog_id,
         SYSDATE);

Line: 527

        | to update wip_period_balances.
        |----------------------------------------------------------*/

        stmt_num := 30;

Line: 532

        select count(*)
        into l_row_count
        from
        mtl_cst_actual_cost_details
        where
        transaction_id = l_trx_id;

Line: 571

                select entity_type
                into l_entity_type
                from wip_entities
                where wip_entity_id = l_wip_entity_id;

Line: 576

                /* Update Asset cost for eam jobs */
                if (l_entity_type in (6,7)) then
                   if l_debug = 'Y' then
		   FND_FILE.PUT_LINE(FND_FILE.log, 'calling eamCost_pub.process_matCost ');