DBA Data[Home] [Help]

APPS.QLTDACTB dependencies on CSI_ITEM_INSTANCES

Line 411: FROM csi_item_instances cii,

407: -- if the eam_item_type has value 1(asset group) or 3(rebuildable)
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