DBA Data[Home] [Help]

APPS.CSM_MULTI_MOBQRY_PKG dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1426: FROM csp_available_parts_temp acc, mtl_system_items_kfv msik, mtl_system_items_tl tl ,fnd_lookup_values flv

1422: msik.concatenated_segments as item_name, msik.serial_number_control_code as serial_number_control_code,
1423: tl.description as description, msik.primary_uom_code as uom_code,msik.comms_nl_trackable_flag as comms_nl_trackable_flag,
1424: msik.material_billable_flag, msik.RESTRICT_LOCATORS_CODE, msik.LOCATION_CONTROL_CODE, msik.restrict_subinventories_code, msik.RECOVERED_PART_DISP_CODE
1425: ,flv.meaning as ship_method_meaning
1426: FROM csp_available_parts_temp acc, mtl_system_items_kfv msik, mtl_system_items_tl tl ,fnd_lookup_values flv
1427: WHERE msik.inventory_item_id = acc.supplied_item_id AND msik.organization_id = acc.organization_id
1428: AND acc.required_item_id=b_req_item_id
1429: AND msik.mtl_transactions_enabled_flag = 'Y' AND tl.inventory_item_id = msik.inventory_item_id
1430: AND tl.organization_id = msik.organization_id AND tl.LANGUAGE = asg_base.get_language(p_user_name)