APPS.CSD_INTERNAL_ORDERS_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 63: FROM mtl_system_items_b msi, mtl_item_sub_defaults mis,csd_product_transactions cpt

59: msi.inventory_item_id,mis.subinventory_code,cpt.rcv_into_org,cpt.rcv_into_ou,
60: msi.primary_unit_of_measure
61: INTO l_serial_control_flag,l_lot_control_flag,l_primary_uom,
62: l_inventory_item_id,l_subinventory,l_to_org_id,l_destn_ou,l_uom
63: FROM mtl_system_items_b msi, mtl_item_sub_defaults mis,csd_product_transactions cpt
64: WHERE cpt.product_transaction_id = p_product_txn_id
65: AND cpt.rcv_into_org = msi.organization_id
66: AND cpt.inventory_item_id = msi.inventory_item_id
67: AND msi.organization_id = mis.organization_id(+)

Line 597: FROM csd_product_transactions cpt,mtl_system_items_b msi

593: l_material_accounts.EXTEND;
594: BEGIN
595: SELECT NVL(p_quantitys(i),cpt.exp_quantity),cpt.inventory_item_id,msi.description,msi.primary_uom_code
596: INTO l_quantitys(i),l_inventory_item_ids(i),l_item_descriptions(i),l_uom_codes(i)
597: FROM csd_product_transactions cpt,mtl_system_items_b msi
598: WHERE cpt.product_transaction_id = p_product_txn_ids(i)
599: AND cpt.inventory_item_id = msi.inventory_item_id
600: AND msi.organization_id = p_destination_orgs(i);
601: EXCEPTION

Line 2320: FROM mtl_system_items_b msi,

2316: SELECT msi.reservable_type,msi.inventory_item_id,
2317: msi.organization_id
2318: INTO l_reservable_flag,l_item_id,
2319: l_org_id
2320: FROM mtl_system_items_b msi,
2321: mtl_txn_request_lines mtrl
2322: WHERE mtrl.inventory_item_id = msi.inventory_item_id
2323: AND mtrl.organization_id = msi.organization_id
2324: AND mtrl.line_id = l_move_order_line_id;