DBA Data[Home] [Help]

APPS.INVKBCGN dependencies on MTL_TASK_V

Line 1204: '(select task_id from mtl_task_v where '||

1200: ', project_name) '|| 'and project_name <= nvl('||
1201: comma||seg_high(v_cnt)||comma||', project_name))';
1202: elsif CUR2.APPLICATION_COLUMN_NAME = 'SEGMENT20' then
1203: v_where := v_append ||' to_number(SEGMENT20) in '||
1204: '(select task_id from mtl_task_v where '||
1205: 'project_id = nvl(to_number(SEGMENT19),project_id) and '||
1206: 'project_name >= nvl('||comma||seg_low(v_cnt)||comma||
1207: ', project_name) '||
1208: 'and project_name <= nvl('||comma||seg_high(v_cnt)||comma||

Line 1494: from mtl_task_v A where

1490: elsif CUR2.APPLICATION_COLUMN_NAME = 'SEGMENT20' then
1491: begin
1492: v_seg20_f := True;
1493: select distinct A.task_name into v_task_name
1494: from mtl_task_v A where
1495: A.task_id = (select nvl(to_number(SEGMENT20), 0)
1496: from mtl_item_locations
1497: where inventory_location_id = X_loc_id and
1498: organization_id = X_org_id ) AND