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.

APPS.CSI_ITEM_INSTANCE_PVT dependencies on INV_PROJECT

Line 2205: select INV_PROJECT.GET_LOCSEGS(milk.INVENTORY_LOCATION_ID,milk.organization_id) ||

2201: --
2202: IF p_instance_header_tbl(tab_row).inv_locator_id IS NOT NULL THEN
2203: Begin
2204: -- Bug 4605780. Modified the query to get Project and Task information.
2205: select INV_PROJECT.GET_LOCSEGS(milk.INVENTORY_LOCATION_ID,milk.organization_id) ||
2206: decode(inv_project.GET_PROJECT_NUMBER(milk.SEGMENT19),'','','.'||
2207: inv_project.GET_PROJECT_NUMBER(milk.SEGMENT19)||
2208: decode(inv_project.GET_TASK_NUMBER(milk.SEGMENT20),'','','.'||
2209: inv_project.GET_TASK_NUMBER(milk.SEGMENT20) ) )

Line 2206: decode(inv_project.GET_PROJECT_NUMBER(milk.SEGMENT19),'','','.'||

2202: IF p_instance_header_tbl(tab_row).inv_locator_id IS NOT NULL THEN
2203: Begin
2204: -- Bug 4605780. Modified the query to get Project and Task information.
2205: select INV_PROJECT.GET_LOCSEGS(milk.INVENTORY_LOCATION_ID,milk.organization_id) ||
2206: decode(inv_project.GET_PROJECT_NUMBER(milk.SEGMENT19),'','','.'||
2207: inv_project.GET_PROJECT_NUMBER(milk.SEGMENT19)||
2208: decode(inv_project.GET_TASK_NUMBER(milk.SEGMENT20),'','','.'||
2209: inv_project.GET_TASK_NUMBER(milk.SEGMENT20) ) )
2210: into p_instance_header_tbl(tab_row).inv_locator_name

Line 2207: inv_project.GET_PROJECT_NUMBER(milk.SEGMENT19)||

2203: Begin
2204: -- Bug 4605780. Modified the query to get Project and Task information.
2205: select INV_PROJECT.GET_LOCSEGS(milk.INVENTORY_LOCATION_ID,milk.organization_id) ||
2206: decode(inv_project.GET_PROJECT_NUMBER(milk.SEGMENT19),'','','.'||
2207: inv_project.GET_PROJECT_NUMBER(milk.SEGMENT19)||
2208: decode(inv_project.GET_TASK_NUMBER(milk.SEGMENT20),'','','.'||
2209: inv_project.GET_TASK_NUMBER(milk.SEGMENT20) ) )
2210: into p_instance_header_tbl(tab_row).inv_locator_name
2211: from MTL_ITEM_LOCATIONS milk

Line 2208: decode(inv_project.GET_TASK_NUMBER(milk.SEGMENT20),'','','.'||

2204: -- Bug 4605780. Modified the query to get Project and Task information.
2205: select INV_PROJECT.GET_LOCSEGS(milk.INVENTORY_LOCATION_ID,milk.organization_id) ||
2206: decode(inv_project.GET_PROJECT_NUMBER(milk.SEGMENT19),'','','.'||
2207: inv_project.GET_PROJECT_NUMBER(milk.SEGMENT19)||
2208: decode(inv_project.GET_TASK_NUMBER(milk.SEGMENT20),'','','.'||
2209: inv_project.GET_TASK_NUMBER(milk.SEGMENT20) ) )
2210: into p_instance_header_tbl(tab_row).inv_locator_name
2211: from MTL_ITEM_LOCATIONS milk
2212: where milk.inventory_location_id = p_instance_header_tbl(tab_row).inv_locator_id;

Line 2209: inv_project.GET_TASK_NUMBER(milk.SEGMENT20) ) )

2205: select INV_PROJECT.GET_LOCSEGS(milk.INVENTORY_LOCATION_ID,milk.organization_id) ||
2206: decode(inv_project.GET_PROJECT_NUMBER(milk.SEGMENT19),'','','.'||
2207: inv_project.GET_PROJECT_NUMBER(milk.SEGMENT19)||
2208: decode(inv_project.GET_TASK_NUMBER(milk.SEGMENT20),'','','.'||
2209: inv_project.GET_TASK_NUMBER(milk.SEGMENT20) ) )
2210: into p_instance_header_tbl(tab_row).inv_locator_name
2211: from MTL_ITEM_LOCATIONS milk
2212: where milk.inventory_location_id = p_instance_header_tbl(tab_row).inv_locator_id;
2213: Exception