DBA Data[Home] [Help]

APPS.AHL_CMP_UTIL_PKG dependencies on FND_FLEX_EXT

Line 654: || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)

650: l_concat_segs VARCHAR2(300);
651:
652: CURSOR get_locator_segments(p_locator_id IN NUMBER)IS
653: SELECT DECODE(MIL.segment19, NULL, MIL_kfv.concatenated_segments, INV_PROJECT.GET_LOCSEGS(MIL_kfv.concatenated_segments)
654: || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
655: || INV_ProjectLocator_PUB.get_project_number(MIL.segment19)
656: || FND_FLEX_EXT.GET_DELIMITER('INV', 'MTLL', 101)
657: || INV_ProjectLocator_PUB.get_task_number(MIL.segment20)) locator_segments
658: FROM MTL_ITEM_LOCATIONS MIL,MTL_ITEM_LOCATIONS_KFV MIL_kfv

Line 656: || FND_FLEX_EXT.GET_DELIMITER('INV', 'MTLL', 101)

652: CURSOR get_locator_segments(p_locator_id IN NUMBER)IS
653: SELECT DECODE(MIL.segment19, NULL, MIL_kfv.concatenated_segments, INV_PROJECT.GET_LOCSEGS(MIL_kfv.concatenated_segments)
654: || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
655: || INV_ProjectLocator_PUB.get_project_number(MIL.segment19)
656: || FND_FLEX_EXT.GET_DELIMITER('INV', 'MTLL', 101)
657: || INV_ProjectLocator_PUB.get_task_number(MIL.segment20)) locator_segments
658: FROM MTL_ITEM_LOCATIONS MIL,MTL_ITEM_LOCATIONS_KFV MIL_kfv
659: WHERE MIL_kfv.INVENTORY_LOCATION_ID = MIL.INVENTORY_LOCATION_ID AND
660: MIL_kfv.ORGANIZATION_ID = MIL.ORGANIZATION_ID AND

Line 666: || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)

662:
663: BEGIN
664:
665: /*SELECT DECODE(MIL.segment19, NULL, MIL.concatenated_segments,INV_PROJECT.GET_LOCSEGS(MIL.concatenated_segments)
666: || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
667: || INV_ProjectLocator_PUB.get_project_number(MIL.segment19)
668: || FND_FLEX_EXT.GET_DELIMITER('INV', 'MTLL', 101)
669: || INV_PROJECTLOCATOR_PUB.GET_TASK_NUMBER(MIL.SEGMENT20))
670: INTO l_concat_segs

Line 668: || FND_FLEX_EXT.GET_DELIMITER('INV', 'MTLL', 101)

664:
665: /*SELECT DECODE(MIL.segment19, NULL, MIL.concatenated_segments,INV_PROJECT.GET_LOCSEGS(MIL.concatenated_segments)
666: || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
667: || INV_ProjectLocator_PUB.get_project_number(MIL.segment19)
668: || FND_FLEX_EXT.GET_DELIMITER('INV', 'MTLL', 101)
669: || INV_PROJECTLOCATOR_PUB.GET_TASK_NUMBER(MIL.SEGMENT20))
670: INTO l_concat_segs
671: FROM MTL_ITEM_LOCATIONS_KFV MIL
672: WHERE MIL.INVENTORY_LOCATION_ID = p_locator_id;*/