APPS.QLTDACTB dependencies on MTL_SYSTEM_ITEMS_B

Line 412: mtl_system_items_b msib,

408: -- ntungare
409: CURSOR Get_eam_item_type(org_id NUMBER, asset_instance_id NUMBER) IS
410: SELECT msib.eam_item_type
411: FROM csi_item_instances cii,
412: mtl_system_items_b msib,
413: mtl_parameters mp
414: WHERE msib.organization_id = mp.organization_id and
415: msib.organization_id = cii.last_vld_organization_id and
416: msib.inventory_item_id = cii.inventory_item_id and

Line 554: FROM mtl_system_items_b

550: -- Bug 3096256. kabalakr Mon Aug 18 03:18:19 PDT 2003.
551:
552: CURSOR item_uom_cur (l_item_id NUMBER, l_org_id NUMBER) IS
553: SELECT primary_unit_of_measure
554: FROM mtl_system_items_b
555: WHERE inventory_item_id = l_item_id
556: AND organization_id = l_org_id;
557:
558: X_LPN_ID NUMBER;