DBA Data[Home] [Help]

APPS.AHL_OSP_RCV_PVT dependencies on FND_FLEX_EXT

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

3162: WHERE MIL_kfv.INVENTORY_LOCATION_ID = MIL.INVENTORY_LOCATION_ID AND
3163: MIL_kfv.ORGANIZATION_ID = MIL.ORGANIZATION_ID AND
3164: MIL_kfv.ORGANIZATION_ID = c_org_id
3165: AND UPPER(DECODE(MIL.segment19, NULL, MIL_kfv.concatenated_segments, INV_PROJECT.GET_LOCSEGS(MIL_kfv.concatenated_segments)
3166: || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
3167: || INV_ProjectLocator_PUB.get_project_number(MIL.segment19)
3168: || FND_FLEX_EXT.GET_DELIMITER('INV', 'MTLL', 101)
3169: || INV_ProjectLocator_PUB.get_task_number(MIL.segment20))) = UPPER(c_locator_name)
3170: AND ((MIL.START_DATE_ACTIVE IS NULL) OR (MIL.START_DATE_ACTIVE <= SYSDATE))

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

3164: MIL_kfv.ORGANIZATION_ID = c_org_id
3165: AND UPPER(DECODE(MIL.segment19, NULL, MIL_kfv.concatenated_segments, INV_PROJECT.GET_LOCSEGS(MIL_kfv.concatenated_segments)
3166: || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
3167: || INV_ProjectLocator_PUB.get_project_number(MIL.segment19)
3168: || FND_FLEX_EXT.GET_DELIMITER('INV', 'MTLL', 101)
3169: || INV_ProjectLocator_PUB.get_task_number(MIL.segment20))) = UPPER(c_locator_name)
3170: AND ((MIL.START_DATE_ACTIVE IS NULL) OR (MIL.START_DATE_ACTIVE <= SYSDATE))
3171: AND ((MIL.END_DATE_ACTIVE IS NULL) OR (MIL.END_DATE_ACTIVE > SYSDATE));
3172: