DBA Data[Home] [Help]

APPS.CSM_MULTI_MOBQRY_PKG dependencies on FND_LOOKUP_VALUES

Line 299: fnd_lookup_values fl,

295: from csp_receiving_headers_v hdr,
296: csp_receiving_lines_v line,
297: jtf_tasks_b task,
298: MTL_UNITS_OF_MEASURE_TL mt,
299: fnd_lookup_values fl,
300: asg_user au
301: where line.header_id = hdr.header_id
302: and hdr.task_number=task.task_number
303: and au.user_name=p_user_name

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)