APPS.GMF_LOT_COSTING_PUB dependencies on GMF_LOT_COST_ADJUSTMENTS

Line 201: --* 06-May-2004 umoogala Updating gmf_lot_cost_adjustments rows even in trial run for subledger to*

197: --* the SLU as most of the time there will not be a new cost. *
198: --* *
199: --* 05-May-2004 PJS Reworked the fix for bug 3578680 for TRNI etc. *
200: --* *
201: --* 06-May-2004 umoogala Updating gmf_lot_cost_adjustments rows even in trial run for subledger to*
202: --* process. Only in final mode applied_ind is set to 'Y'. No bug was created*
203: --* *
204: --* 25-May-2004 PJS Bug 3643858. Include delete mark on LADJ cursor. *
205: --* *

Line 10642: FROM gmf_lot_cost_adjustments glca,

10638: glca.adjustment_date as oc1,
10639: 0 as oc2,
10640: -9 as oc3,
10641: 0 as routing_id
10642: FROM gmf_lot_cost_adjustments glca,
10643: -- mtl_system_items_b iimb,
10644: gmf_lot_costed_items_gt glci
10645: WHERE glca.applied_ind = 'N'
10646: -- AND glca.adjustment_date >= NVL(l_trans_start_date, glca.adjustment_date) changed for performance as below B14616815

Line 11021: FROM gmf_lot_cost_adjustments glca,

11017: glca.adjustment_date as oc1,
11018: 0 as oc2,
11019: -9 as oc3,
11020: 0 as routing_id
11021: FROM gmf_lot_cost_adjustments glca,
11022: -- mtl_system_items_b iimb,
11023: gmf_lot_costed_items_gt glci
11024: WHERE glca.applied_ind = 'N'
11025: -- AND glca.adjustment_date >= NVL(l_trans_start_date, glca.adjustment_date) changed for performance as below B14616815

Line 11691: UPDATE gmf_lot_cost_adjustments

11687: (fnd_file.log,'FINAL Mode old '||old_cost.header_id||' new '||new_cost.header_id||' Onhand '||new_cost.onhand_qty||' adj '||transaction_row.doc_id);
11688: END IF;
11689:
11690:
11691: UPDATE gmf_lot_cost_adjustments
11692: SET applied_ind = 'Y',
11693: old_cost_header_id = NVL(old_cost.header_id, new_cost.header_id),
11694: new_cost_header_id = new_cost.header_id,
11695: onhand_qty = new_cost.onhand_qty

Line 11711: UPDATE gmf_lot_cost_adjustments

11707:
11708: ELSE
11709: IF transaction_row.source = 3 THEN
11710: -- PK Bug 6697946 If old_cost.header_id is NULL Use new_cost.header_id
11711: UPDATE gmf_lot_cost_adjustments
11712: SET old_cost_header_id = NVL(old_cost.header_id, new_cost.header_id),
11713: new_cost_header_id = new_cost.header_id,
11714: onhand_qty = new_cost.onhand_qty
11715: WHERE adjustment_id = transaction_row.doc_id;