[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
591: /* Fix for bug 4155822: Need not multiply with PO quantity since we multiply with
592: resource primary quantity to get the cost later
593: SELECT rti.primary_quantity
594: INTO l_po_qty
595: FROM mtl_system_items msi, rcv_transactions_interface rti
596: WHERE msi.inventory_item_id = rti.item_id
597: AND msi.organization_id = rti.to_organization_id
598: AND rti.interface_transaction_id = g_Res_rec.source_line_id; */
599:
1977: -- Calculate the transaction quantity.
1978:
1979: SELECT msi.outside_operation_uom_type, rti.primary_quantity
1980: INTO l_uom_basis, l_po_qty
1981: FROM mtl_system_items msi, rcv_transactions_interface rti
1982: WHERE msi.inventory_item_id = rti.item_id
1983: AND msi.organization_id = rti.to_organization_id
1984: AND rti.interface_transaction_id = g_Res_rec.source_line_id;
1985: