DBA Data[Home] [Help]

APPS.CST_EAMCOST_PUB dependencies on MTL_UNITS_OF_MEASURE

Line 6432: FROM mtl_units_of_measure

6428: IF ( l_po_order_type_lookup_code <> 'FIXED PRICE') THEN /*ADDED FOR BUG 7668184*/
6429:
6430: SELECT uom_code
6431: INTO l_source_doc_uom_code
6432: FROM mtl_units_of_measure
6433: WHERE unit_of_measure = l_source_doc_unit_of_measure;
6434:
6435: l_directItem_rec.primary_uom := l_source_doc_uom_code;
6436: l_directItem_rec.primary_quantity := l_quantity; /* populate primary_quantity as source doc quantity */

Line 6561: mtl_units_of_measure muom,

6557: l_directItem_rec.usage_rate_or_amount,
6558: l_directItem_rec.wip_entity_id
6559: from rcv_transactions_interface rti,
6560: po_distributions_all pod,
6561: mtl_units_of_measure muom,
6562: mtl_units_of_measure puom
6563: where rti.interface_transaction_id = l_interface_txn_id
6564: and rti.po_distribution_id = pod.po_distribution_id
6565: and puom.unit_of_measure(+) = rti.unit_of_measure

Line 6562: mtl_units_of_measure puom

6558: l_directItem_rec.wip_entity_id
6559: from rcv_transactions_interface rti,
6560: po_distributions_all pod,
6561: mtl_units_of_measure muom,
6562: mtl_units_of_measure puom
6563: where rti.interface_transaction_id = l_interface_txn_id
6564: and rti.po_distribution_id = pod.po_distribution_id
6565: and puom.unit_of_measure(+) = rti.unit_of_measure
6566: and muom.uom_class(+) = puom.uom_class

Line 10625: mtl_units_of_measure uom,

10621: poh.type_lookup_code, -- DOCUMENT_TYPE
10622: to_char(null) -- IS_SHARED_PROC
10623: FROM
10624: po_line_types plt,
10625: mtl_units_of_measure uom,
10626: po_headers_all poh,
10627: wip_eam_direct_items wed,
10628: hr_organization_information hoi,
10629: wip_operations wo,

Line 10806: mtl_units_of_measure uom,

10802: FROM
10803: po_requisition_lines_all rql,
10804: po_requisition_headers_all rqh,
10805: po_line_types plt,
10806: mtl_units_of_measure uom,
10807: wip_eam_direct_items wed,
10808: hr_organization_information hoi,
10809: wip_operations wo
10810: WHERE