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 595: FROM mtl_system_items msi, rcv_transactions_interface rti

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:

Line 1981: FROM mtl_system_items msi, rcv_transactions_interface rti

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: