eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.INVKBCGN dependencies on MTL_TASK_V

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

1626: ', project_name) '|| 'and project_name <= nvl('||
1627: comma||seg_high(v_cnt)||comma||', project_name))';
1628: elsif CUR2.APPLICATION_COLUMN_NAME = 'SEGMENT20' then
1629: v_where := v_append ||' to_number(SEGMENT20) in '||
1630: '(select task_id from mtl_task_v where '||
1631: 'project_id = nvl(to_number(SEGMENT19),project_id) and '||
1632: 'project_name >= nvl('||comma||seg_low(v_cnt)||comma||
1633: ', project_name) '||
1634: 'and project_name <= nvl('||comma||seg_high(v_cnt)||comma||

Line 1947: from mtl_task_v A where

1943: elsif CUR2.APPLICATION_COLUMN_NAME = 'SEGMENT20' then
1944: begin
1945: v_seg20_f := True;
1946: select distinct A.task_name into v_task_name
1947: from mtl_task_v A where
1948: A.task_id = (select nvl(to_number(SEGMENT20), 0)
1949: from mtl_item_locations
1950: where inventory_location_id = X_loc_id and
1951: organization_id = X_org_id ) AND