DBA Data[Home] [Help]

APPS.CS_SR_FUL_PKG dependencies on FND_PROFILE

Line 344: where item.organization_id = fnd_profile.value('CS_INV_VALIDATION_ORG')

340: select incident.platform_version,item.concatenated_segments platform
341: from mtl_system_items_vl item,
342: mtl_item_categories ic,
343: cs_sr_incidents_v incident
344: where item.organization_id = fnd_profile.value('CS_INV_VALIDATION_ORG')
345: and item.serv_req_enabled_code = 'E'
346: and item.organization_id = ic.organization_id
347: and item.inventory_item_id = ic.inventory_item_id
348: and ic.category_set_id = fnd_profile.value('CS_SR_PLATFORM_CATEGORY_SET')

Line 348: and ic.category_set_id = fnd_profile.value('CS_SR_PLATFORM_CATEGORY_SET')

344: where item.organization_id = fnd_profile.value('CS_INV_VALIDATION_ORG')
345: and item.serv_req_enabled_code = 'E'
346: and item.organization_id = ic.organization_id
347: and item.inventory_item_id = ic.inventory_item_id
348: and ic.category_set_id = fnd_profile.value('CS_SR_PLATFORM_CATEGORY_SET')
349: and item.inventory_item_id = incident.platform_id
350: and item.inventory_item_id = l_platform_id
351: and incident.incident_id = l_incident_id ;
352:

Line 427: FND_PROFILE.GET('CS_SR_DEFAULT_AGENT_COMMENTS',l_note_type);

423: null;
424: end if;
425: CLOSE inc_log_csr; */
426:
427: FND_PROFILE.GET('CS_SR_DEFAULT_AGENT_COMMENTS',l_note_type);
428: if (l_note_type is not null) then
429: OPEN inc_notes_csr ;
430: FETCH inc_notes_csr into fulfillment_user_note ;
431: if(inc_notes_csr%notfound) then