[Home] [Help]
6074: IF ( l_po_order_type_lookup_code <> 'FIXED PRICE') THEN /*ADDED FOR BUG 7668184*/
6075:
6076: SELECT uom_code
6077: INTO l_source_doc_uom_code
6078: FROM mtl_units_of_measure
6079: WHERE unit_of_measure = l_source_doc_unit_of_measure;
6080:
6081: l_directItem_rec.primary_uom := l_source_doc_uom_code;
6082: l_directItem_rec.primary_quantity := l_quantity; /* populate primary_quantity as source doc quantity */
6203: l_directItem_rec.usage_rate_or_amount,
6204: l_directItem_rec.wip_entity_id
6205: from rcv_transactions_interface rti,
6206: po_distributions_all pod,
6207: mtl_units_of_measure muom,
6208: mtl_units_of_measure puom
6209: where rti.interface_transaction_id = l_interface_txn_id
6210: and rti.po_distribution_id = pod.po_distribution_id
6211: and puom.unit_of_measure(+) = rti.unit_of_measure
6204: l_directItem_rec.wip_entity_id
6205: from rcv_transactions_interface rti,
6206: po_distributions_all pod,
6207: mtl_units_of_measure muom,
6208: mtl_units_of_measure puom
6209: where rti.interface_transaction_id = l_interface_txn_id
6210: and rti.po_distribution_id = pod.po_distribution_id
6211: and puom.unit_of_measure(+) = rti.unit_of_measure
6212: and muom.uom_class(+) = puom.uom_class
9908: poh.type_lookup_code, -- DOCUMENT_TYPE
9909: to_char(null) -- IS_SHARED_PROC
9910: FROM
9911: po_line_types plt,
9912: mtl_units_of_measure uom,
9913: po_headers_all poh,
9914: wip_eam_direct_items wed,
9915: hr_organization_information hoi,
9916: wip_operations wo,
10089: FROM
10090: po_requisition_lines_all rql,
10091: po_requisition_headers_all rqh,
10092: po_line_types plt,
10093: mtl_units_of_measure uom,
10094: wip_eam_direct_items wed,
10095: hr_organization_information hoi,
10096: wip_operations wo
10097: WHERE