APPS.GMF_LOT_COSTING_PUB dependencies on MTL_UNITS_OF_MEASURE

Line 2220: mtl_units_of_measure uom,

2216: ,uom.uom_code
2217: FROM rcv_transactions t,
2218: po_rcv_charges rc,
2219: po_rcv_charge_allocations rca,
2220: mtl_units_of_measure uom,
2221: mtl_material_transactions mmt /* ANTHIYAG Bug#5463200 14-Aug-2006 */
2222: WHERE mmt.transaction_id = transaction_row.transaction_id /* ANTHIYAG Bug#5463200 14-Aug-2006 */
2223: AND t.transaction_id = mmt.rcv_transaction_id
2224: AND t.shipment_header_id = rc.shipment_header_id

Line 3542: FROM rcv_transactions t, mtl_units_of_measure u, mtl_material_transactions mmt -- jboppana

3538: receipt_qty,
3539: receipt_uom,
3540: document_code,
3541: l_exchange_rate
3542: FROM rcv_transactions t, mtl_units_of_measure u, mtl_material_transactions mmt -- jboppana
3543: , po_distributions_all pda
3544: WHERE t.source_doc_unit_of_measure = u.unit_of_measure(+)
3545: AND t.transaction_id = mmt.rcv_transaction_id
3546: -- AND mmt.transaction_source_id = transaction_row.doc_id

Line 4518: FROM mtl_units_of_measure

4514: END IF;
4515:
4516:
4517: SELECT uom_code INTO l_step_tab(1).step_qty_uom
4518: FROM mtl_units_of_measure
4519: WHERE uom_class = l_um_type AND base_uom_flag = 'Y';
4520:
4521: ELSE
4522: fnd_file.put_line(fnd_file.log,' Entering else part of l_routing=0');

Line 7279: FROM mtl_units_of_measure u,

7275: END IF;
7276:
7277: UPDATE gmf_process_organizations_gt gpo
7278: SET std_uom = (SELECT u.uom_code
7279: FROM mtl_units_of_measure u,
7280: gmd_parameters_hdr h,
7281: gmd_parameters_dtl d
7282: WHERE u.base_uom_flag = 'Y'
7283: AND gpo.organization_id = h.organization_id

Line 7291: FROM mtl_units_of_measure u,

7287: WHERE gpo.std_uom IS NULL;
7288:
7289: UPDATE gmf_process_organizations_gt gpo
7290: SET std_uom = (SELECT u.uom_code
7291: FROM mtl_units_of_measure u,
7292: gmd_parameters_hdr h,
7293: gmd_parameters_dtl d
7294: WHERE u.base_uom_flag = 'Y'
7295: AND h.organization_id IS NULL