APPS.GMF_LOT_COSTING_PUB dependencies on GMF_LOT_COST_ADJUSTMENT_DTLS

Line 144: --* 18-Mar-2004 umoogala Lot Cost Adjustment query fix. Removed ref to gmf_lot_cost_adjustment_dtls*

140: --* 17-Mar-2004 PJS Various issues with cost adjustments. Altered cursors to respect delete *
141: --* marks and retrieve the item's primary uom. Also avoided in/out clash in *
142: --* call to create_header. No bug reference. *
143: --* *
144: --* 18-Mar-2004 umoogala Lot Cost Adjustment query fix. Removed ref to gmf_lot_cost_adjustment_dtls*
145: --* *
146: --* 19-Mar-2004 PJS Bug 3514108 - RMA fixes and Bug 3513668 - Requisitions *
147: --* *
148: --* 22-Mar-2004 PJS Reworked 3485915 and 3476427. Also tightened up error messaging for the *

Line 6621: FROM gmf_lot_cost_adjustment_dtls lcad

6617: , 0
6618: , lcad.adjustment_cost
6619: , 0
6620: )
6621: FROM gmf_lot_cost_adjustment_dtls lcad
6622: WHERE lcad.adjustment_id = transaction_row.doc_id
6623: AND lcad.delete_mark = 0;
6624:
6625: new_unit_cost NUMBER;

Line 8870: (SELECT 1 FROM gmf_lot_cost_adjustment_dtls

8866: AND glca.organization_id = glci.organization_id
8867: AND glca.adjustment_date <= l_final_run_date
8868: AND glca.lot_number = nvl(p_lot_no,glca.lot_number)
8869: AND EXISTS
8870: (SELECT 1 FROM gmf_lot_cost_adjustment_dtls
8871: WHERE adjustment_id = glca.adjustment_id
8872: AND delete_mark = 0
8873: )
8874: )