DBA Data[Home] [Help]

APPS.WIP_DEFAULT_RES dependencies on MTL_SYSTEM_ITEMS

Line 525: FROM mtl_system_items msi

521: END IF;
522:
523: SELECT msi.outside_operation_uom_type
524: INTO l_uom_basis
525: FROM mtl_system_items msi
526: WHERE msi.inventory_item_id = g_RCV_txn.item_id
527: AND msi.organization_id = g_RCV_txn.organization_id;
528:
529: /* Fixed for Bug#2031267 */

Line 597: FROM mtl_system_items msi, rcv_transactions_interface rti

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:

Line 1985: FROM mtl_system_items msi, rcv_transactions_interface rti

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: