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) ) )
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
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
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;
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