[Home] [Help]
1094: WHERE glcd.header_id = p_header_id;
1095:
1096: --**********************************************************************************************
1097: --* *
1098: --* Cursors to retrieve the standard cost of an item in the organization specified. *
1099: --* umoogala: passing co_code instead of calendar_code. Also, joined with cldr_hdr. *
1100: --* Dinesh Vadivel - Bug 4320765 - Modified item_cost_cursor to support warehouse association
1101: --* functionality for the Alternate Cost Method *
1102: --**********************************************************************************************
4594: INSERT INTO gme_batch_step_dependencies
4595: ( batch_id
4596: , batchstep_id
4597: , dep_step_id
4598: , standard_delay
4599: , dep_type
4600: , created_by
4601: , creation_date
4602: , last_updated_by
4674: INSERT INTO gme_batch_step_dependencies
4675: ( batch_id
4676: , batchstep_id
4677: , dep_step_id
4678: , standard_delay
4679: , dep_type
4680: , created_by
4681: , creation_date
4682: , last_updated_by
5199: -- The transactions are sorted by date and then by line type. This should
5200: -- give the correct ordering of transactions for the rollup.
5201:
5202: -- If item is not lot controlled or is not lot costed
5203: -- use the standard (period-based) cost from cm_cmpt_dtl,
5204: -- otherwise use the lot cost
5205:
5206: IF l_step_tab(i).materials(j).line_type IN (-1,2) -- Treat byproducts as negative ingredients
5207: OR l_step_tab(i).materials(j).line_type = 1 AND l_step_tab(i).materials(j).lot_costed_flag = 0
5326: END LOOP;
5327: END IF;
5328: ELSE
5329: -- This is a product/coproduct that is yielded at this step. If the item
5330: -- being yielded uses standard costing we extract the cost so that we can
5331: -- work out the cost of this transaction and then include it in the total
5332: -- for this step. Any items that use lot costing have these costs calculated
5333: -- after we've rolled up the costs into the step from where the lot is yielded
5334:
9092:
9093: -- This is a product line of some kind. If the batch has been uncertified the usually positive
9094: -- transaction quantity will be negative. This is similar to a PO return.
9095:
9096: -- The costs come from both standard and lot-costed items, together with any resource costs
9097: -- and burdens. If the lot being yielded does not have a cost in this organization, the procedure
9098: -- will set them up.
9099:
9100: -- If there is already a cost for this lot and organization then the costs will be updated