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 */
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
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
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,
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