[Home] [Help]
5: ** --------------------------------------------------------------------------
6: ** Procedure :Get_Decription
7: ** Decription: This procedure accepts thedentofiers and returns the
8: ** description for the identifiers. The following columns
9: ** from mtl_material_transactions are passed as input for
10: ** this procedure
11: **
12: ** TRANSACTION_TYPE_ID
13: ** TRANSACTION_ACTION_ID
462: END GET_DESCRIPTION;
463: /*
464: ** --------------------------------------------------------------------------
465: ** Procedure :update_mmt_process_cost
466: ** Decription: This procedure updates the mtl_material_transactions table
467: ** with the cost fetched from the GMF api for the items
468: ** in process enabled organizations. It updates for the all items
469: ** having transactions in the given organization between the
470: ** transaction dates used in the reports, Transaction Register
524: IF l_process_org = 1 THEN
525: IF p_report = 'T' THEN
526: sqlstmt := 'select distinct i.organization_id ,i.inventory_item_id,
527: i.transaction_date '
528: ||' from mtl_material_Transactions i '
529: ||' where i.organization_id = :org_id '
530: ||' and i.transaction_date between :from_date '
531: ||' and :to_date ';
532: ELSIF p_report = 'L' THEN
531: ||' and :to_date ';
532: ELSIF p_report = 'L' THEN
533: sqlstmt := 'select distinct i.organization_id ,
534: i.inventory_item_id, i.transaction_date '
535: ||' from mtl_material_Transactions i, mtl_transaction_lot_numbers
536: l '
537: ||' where i.transaction_id = l.transaction_id '
538: ||' and l.organization_id = :org_id '
539: ||' and l.transaction_date between :from_date '
567: else
568: v_cost := 0;
569: end if;
570:
571: update mtl_material_transactions
572: set actual_cost = v_cost
573: where organization_id = l_organization_id
574: and inventory_item_id = l_inventory_item_id
575: and transaction_date = l_transaction_date;