[Home] [Help]
20: g_BOM_res WIP_Transaction_PUB.BOM_Resource_Type;
21:
22: -- Get functions.
23:
24: /* Private Procedure that will populate all the attributes from RCV_TRANSACTIONS_INTERFACE. Populating each attribute individually will be a performance hit, so call this procedure once */
25: PROCEDURE get_rti_attr
26: IS
27:
28: l_wip_entity_id NUMBER := FND_API.G_MISS_NUM;
110: , l_currency_code
111: , l_currency_conversion_type
112: , l_currency_conversion_rate
113: , l_currency_conversion_date
114: FROM RCV_TRANSACTIONS_INTERFACE
115: WHERE interface_transaction_id = g_Res_rec.source_line_id;
116:
117:
118: IF g_RCV_txn.quantity IS NULL THEN
315: , l_task_id
316: , l_nonrecoverable_tax
317: , l_quantity_ordered
318: FROM po_distributions_all pd,
319: rcv_transactions_interface rti
320: WHERE rti.po_distribution_id = pd.po_distribution_id
321: AND rti.interface_transaction_id = g_Res_rec.source_line_id;
322:
323: IF g_PO_Dstr.project_id IS NULL THEN
593: /* Fix for bug 4155822: Need not multiply with PO quantity since we multiply with
594: resource primary quantity to get the cost later
595: SELECT rti.primary_quantity
596: INTO l_po_qty
597: FROM mtl_system_items msi, rcv_transactions_interface rti
598: WHERE msi.inventory_item_id = rti.item_id
599: AND msi.organization_id = rti.to_organization_id
600: AND rti.interface_transaction_id = g_Res_rec.source_line_id;
601:
1981: -- Calculate the transaction quantity.
1982:
1983: SELECT msi.outside_operation_uom_type, rti.primary_quantity
1984: INTO l_uom_basis, l_po_qty
1985: FROM mtl_system_items msi, rcv_transactions_interface rti
1986: WHERE msi.inventory_item_id = rti.item_id
1987: AND msi.organization_id = rti.to_organization_id
1988: AND rti.interface_transaction_id = g_Res_rec.source_line_id;
1989: