[Home] [Help]
1351: WHERE glcd.header_id = p_header_id;
1352:
1353: --**********************************************************************************************
1354: --* *
1355: --* Cursors to retrieve the standard cost of an item in the organization specified. *
1356: --* umoogala: passing co_code instead of calendar_code. Also, joined with cldr_hdr. *
1357: --* Dinesh Vadivel - Bug 4320765 - Modified item_cost_cursor to support warehouse association
1358: --* functionality for the Alternate Cost Method
1359: --* Hari Luthra - Bug 8533290/5473138 Modified item_cost_cursor and item_cost_detail_cursor to avoid issues in case of
5259: INSERT INTO gme_batch_step_dependencies
5260: ( batch_id
5261: , batchstep_id
5262: , dep_step_id
5263: , standard_delay
5264: , dep_type
5265: , created_by
5266: , creation_date
5267: , last_updated_by
5337: INSERT INTO gme_batch_step_dependencies
5338: ( batch_id
5339: , batchstep_id
5340: , dep_step_id
5341: , standard_delay
5342: , dep_type
5343: , created_by
5344: , creation_date
5345: , last_updated_by
5936: -- The transactions are sorted by date and then by line type. This should
5937: -- give the correct ordering of transactions for the rollup.
5938:
5939: -- If item is not lot controlled or is not lot costed
5940: -- use the standard (period-based) cost from cm_cmpt_dtl,
5941: -- otherwise use the lot cost
5942: -- B9131983
5943: IF l_step_tab(i).materials(j).line_type IN (-1,2) -- Treat byproducts as negative ingredients
5944: OR l_step_tab(i).materials(j).line_type = 1 AND l_step_tab(i).materials(j).lot_costed_flag = 0
6189: END LOOP;
6190: END IF;
6191: ELSE
6192: -- This is a product/coproduct that is yielded at this step. If the item
6193: -- being yielded uses standard costing we extract the cost so that we can
6194: -- work out the cost of this transaction and then include it in the total
6195: -- for this step. Any items that use lot costing have these costs calculated
6196: -- after we've rolled up the costs into the step from where the lot is yielded
6197:
11449:
11450: -- This is a product line of some kind. If the batch has been uncertified the usually positive
11451: -- transaction quantity will be negative. This is similar to a PO return.
11452:
11453: -- The costs come from both standard and lot-costed items, together with any resource costs
11454: -- and burdens. If the lot being yielded does not have a cost in this organization, the procedure
11455: -- will set them up.
11456:
11457: -- If there is already a cost for this lot and organization then the costs will be updated