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.WMS_RULE_10 SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 55


        OPEN p_cursor FOR select base.SUBINVENTORY_CODE
,base.LOCATOR_ID
,base.PROJECT_ID
,base.TASK_ID
 from MTL_SYSTEM_ITEMS msi
,WMS_TRX_DETAILS_TMP_V mptdtv
,(
 select  msei.secondary_inventory_name subinventory_code               --changed
        ,mil.inventory_location_id locator_id
        ,msei.organization_id organization_id                          --changed
        ,mil.project_id project_id
        ,mil.task_id task_id
        ,g_inventory_item_id inventory_item_id
        ,mil.location_current_units location_current_units
        ,mil.inventory_item_id locator_inventory_item_id
        ,mil.empty_flag empty_flag
        ,mil.mixed_items_flag mixed_items_flag
        ,mil.LAST_UPDATE_DATE
        ,mil.LAST_UPDATED_BY
        ,mil.CREATION_DATE
        ,mil.CREATED_BY
        ,mil.LAST_UPDATE_LOGIN
        ,mil.DESCRIPTION
        ,mil.DESCRIPTIVE_TEXT
        ,mil.DISABLE_DATE
        ,mil.INVENTORY_LOCATION_TYPE
        ,mil.PICKING_ORDER
        ,mil.PHYSICAL_LOCATION_CODE
        ,mil.LOCATION_MAXIMUM_UNITS
        ,mil.LOCATION_WEIGHT_UOM_CODE
        ,mil.MAX_WEIGHT
        ,mil.VOLUME_UOM_CODE
        ,mil.MAX_CUBIC_AREA
        ,mil.X_COORDINATE
        ,mil.Y_COORDINATE
        ,mil.Z_COORDINATE
        ,mil.INVENTORY_ACCOUNT_ID
        ,mil.SEGMENT1
        ,mil.SEGMENT2
        ,mil.SEGMENT3
        ,mil.SEGMENT4
        ,mil.SEGMENT5
        ,mil.SEGMENT6
        ,mil.SEGMENT7
        ,mil.SEGMENT8
        ,mil.SEGMENT9
        ,mil.SEGMENT10
        ,mil.SEGMENT11
        ,mil.SEGMENT12
        ,mil.SEGMENT13
        ,mil.SEGMENT14
        ,mil.SEGMENT15
        ,mil.SEGMENT16
        ,mil.SEGMENT17
        ,mil.SEGMENT18
        ,mil.SEGMENT19
        ,mil.SEGMENT20
        ,mil.SUMMARY_FLAG
        ,mil.ENABLED_FLAG
        ,mil.START_DATE_ACTIVE
        ,mil.END_DATE_ACTIVE
        ,mil.ATTRIBUTE_CATEGORY
        ,mil.ATTRIBUTE1
        ,mil.ATTRIBUTE2
        ,mil.ATTRIBUTE3
        ,mil.ATTRIBUTE4
        ,mil.ATTRIBUTE5
        ,mil.ATTRIBUTE6
        ,mil.ATTRIBUTE7
        ,mil.ATTRIBUTE8
        ,mil.ATTRIBUTE9
        ,mil.ATTRIBUTE10
        ,mil.ATTRIBUTE11
        ,mil.ATTRIBUTE12
        ,mil.ATTRIBUTE13
        ,mil.ATTRIBUTE14
        ,mil.ATTRIBUTE15
        ,mil.REQUEST_ID
        ,mil.PROGRAM_APPLICATION_ID
        ,mil.PROGRAM_ID
        ,mil.PROGRAM_UPDATE_DATE
        ,mil.PHYSICAL_LOCATION_ID
        ,mil.PICK_UOM_CODE
        ,mil.DIMENSION_UOM_CODE
        ,mil.LENGTH
        ,mil.WIDTH
        ,mil.HEIGHT
        ,mil.LOCATOR_STATUS
        ,mil.STATUS_ID
        ,mil.CURRENT_CUBIC_AREA
        ,mil.AVAILABLE_CUBIC_AREA
        ,mil.CURRENT_WEIGHT
        ,mil.AVAILABLE_WEIGHT
        ,mil.LOCATION_AVAILABLE_UNITS
        ,mil.SUGGESTED_CUBIC_AREA
        ,mil.SUGGESTED_WEIGHT
        ,mil.LOCATION_SUGGESTED_UNITS
        ,mil.rowid
   from MTL_ITEM_LOCATIONS mil
       ,MTL_SECONDARY_INVENTORIES msei
  where mil.organization_id(+) = msei.organization_id
    and mil.subinventory_code(+) = msei.secondary_inventory_name
    and NVL(msei.disable_date, sysdate+1) > sysdate
    and NVL(mil.disable_date, sysdate+1) > sysdate
)base
 where base.ORGANIZATION_ID = g_organization_id
and base.INVENTORY_ITEM_ID = g_inventory_item_id
 and (g_project_id = base.project_id OR base.project_id IS NULL)
 and (g_task_id = base.task_id OR base.task_id IS NULL)
 and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
 order by WMS_Parameter_PVT.GetItemOnHand(
base.ORGANIZATION_ID
,mptdtv.INVENTORY_ITEM_ID
,base.SUBINVENTORY_CODE
,base.LOCATOR_ID
,msi.PRIMARY_UOM_CODE
,mptdtv.TRANSACTION_UOM ) desc
,base.PROJECT_ID
,base.TASK_ID
;

Line: 182


        OPEN p_cursor FOR select base.SUBINVENTORY_CODE
,base.LOCATOR_ID
,base.PROJECT_ID
,base.TASK_ID
 from MTL_SYSTEM_ITEMS msi
,WMS_TRX_DETAILS_TMP_V mptdtv
,(
 select  msei.secondary_inventory_name subinventory_code               --changed
        ,mil.inventory_location_id locator_id
        ,msei.organization_id organization_id                          --changed
        ,mil.project_id project_id
        ,mil.task_id task_id
        ,g_inventory_item_id inventory_item_id
        ,mil.location_current_units location_current_units
        ,mil.inventory_item_id locator_inventory_item_id
        ,mil.empty_flag empty_flag
        ,mil.mixed_items_flag mixed_items_flag
        ,mil.LAST_UPDATE_DATE
        ,mil.LAST_UPDATED_BY
        ,mil.CREATION_DATE
        ,mil.CREATED_BY
        ,mil.LAST_UPDATE_LOGIN
        ,mil.DESCRIPTION
        ,mil.DESCRIPTIVE_TEXT
        ,mil.DISABLE_DATE
        ,mil.INVENTORY_LOCATION_TYPE
        ,mil.PICKING_ORDER
        ,mil.PHYSICAL_LOCATION_CODE
        ,mil.LOCATION_MAXIMUM_UNITS
        ,mil.LOCATION_WEIGHT_UOM_CODE
        ,mil.MAX_WEIGHT
        ,mil.VOLUME_UOM_CODE
        ,mil.MAX_CUBIC_AREA
        ,mil.X_COORDINATE
        ,mil.Y_COORDINATE
        ,mil.Z_COORDINATE
        ,mil.INVENTORY_ACCOUNT_ID
        ,mil.SEGMENT1
        ,mil.SEGMENT2
        ,mil.SEGMENT3
        ,mil.SEGMENT4
        ,mil.SEGMENT5
        ,mil.SEGMENT6
        ,mil.SEGMENT7
        ,mil.SEGMENT8
        ,mil.SEGMENT9
        ,mil.SEGMENT10
        ,mil.SEGMENT11
        ,mil.SEGMENT12
        ,mil.SEGMENT13
        ,mil.SEGMENT14
        ,mil.SEGMENT15
        ,mil.SEGMENT16
        ,mil.SEGMENT17
        ,mil.SEGMENT18
        ,mil.SEGMENT19
        ,mil.SEGMENT20
        ,mil.SUMMARY_FLAG
        ,mil.ENABLED_FLAG
        ,mil.START_DATE_ACTIVE
        ,mil.END_DATE_ACTIVE
        ,mil.ATTRIBUTE_CATEGORY
        ,mil.ATTRIBUTE1
        ,mil.ATTRIBUTE2
        ,mil.ATTRIBUTE3
        ,mil.ATTRIBUTE4
        ,mil.ATTRIBUTE5
        ,mil.ATTRIBUTE6
        ,mil.ATTRIBUTE7
        ,mil.ATTRIBUTE8
        ,mil.ATTRIBUTE9
        ,mil.ATTRIBUTE10
        ,mil.ATTRIBUTE11
        ,mil.ATTRIBUTE12
        ,mil.ATTRIBUTE13
        ,mil.ATTRIBUTE14
        ,mil.ATTRIBUTE15
        ,mil.REQUEST_ID
        ,mil.PROGRAM_APPLICATION_ID
        ,mil.PROGRAM_ID
        ,mil.PROGRAM_UPDATE_DATE
        ,mil.PHYSICAL_LOCATION_ID
        ,mil.PICK_UOM_CODE
        ,mil.DIMENSION_UOM_CODE
        ,mil.LENGTH
        ,mil.WIDTH
        ,mil.HEIGHT
        ,mil.LOCATOR_STATUS
        ,mil.STATUS_ID
        ,mil.CURRENT_CUBIC_AREA
        ,mil.AVAILABLE_CUBIC_AREA
        ,mil.CURRENT_WEIGHT
        ,mil.AVAILABLE_WEIGHT
        ,mil.LOCATION_AVAILABLE_UNITS
        ,mil.SUGGESTED_CUBIC_AREA
        ,mil.SUGGESTED_WEIGHT
        ,mil.LOCATION_SUGGESTED_UNITS
        ,mil.rowid
   from MTL_ITEM_LOCATIONS mil
       ,MTL_SECONDARY_INVENTORIES msei
  where mil.organization_id(+) = msei.organization_id
    and mil.subinventory_code(+) = msei.secondary_inventory_name
    and NVL(msei.disable_date, sysdate+1) > sysdate
    and NVL(mil.disable_date, sysdate+1) > sysdate
)base
 where base.ORGANIZATION_ID = g_organization_id
and base.INVENTORY_ITEM_ID = g_inventory_item_id
 and (g_project_id = base.project_id OR base.project_id IS NULL)
 and (g_task_id = base.task_id OR base.task_id IS NULL)
 and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
 and base.subinventory_code = g_subinventory_code
 order by WMS_Parameter_PVT.GetItemOnHand(
base.ORGANIZATION_ID
,mptdtv.INVENTORY_ITEM_ID
,base.SUBINVENTORY_CODE
,base.LOCATOR_ID
,msi.PRIMARY_UOM_CODE
,mptdtv.TRANSACTION_UOM ) desc
,base.PROJECT_ID
,base.TASK_ID
;

Line: 308


        OPEN p_cursor FOR select base.SUBINVENTORY_CODE
,base.LOCATOR_ID
,base.PROJECT_ID
,base.TASK_ID
 from MTL_SYSTEM_ITEMS msi
,WMS_TRX_DETAILS_TMP_V mptdtv
,(
 select  msei.secondary_inventory_name subinventory_code               --changed
        ,mil.inventory_location_id locator_id
        ,msei.organization_id organization_id                          --changed
        ,mil.project_id project_id
        ,mil.task_id task_id
        ,g_inventory_item_id inventory_item_id
        ,mil.location_current_units location_current_units
        ,mil.inventory_item_id locator_inventory_item_id
        ,mil.empty_flag empty_flag
        ,mil.mixed_items_flag mixed_items_flag
        ,mil.LAST_UPDATE_DATE
        ,mil.LAST_UPDATED_BY
        ,mil.CREATION_DATE
        ,mil.CREATED_BY
        ,mil.LAST_UPDATE_LOGIN
        ,mil.DESCRIPTION
        ,mil.DESCRIPTIVE_TEXT
        ,mil.DISABLE_DATE
        ,mil.INVENTORY_LOCATION_TYPE
        ,mil.PICKING_ORDER
        ,mil.PHYSICAL_LOCATION_CODE
        ,mil.LOCATION_MAXIMUM_UNITS
        ,mil.LOCATION_WEIGHT_UOM_CODE
        ,mil.MAX_WEIGHT
        ,mil.VOLUME_UOM_CODE
        ,mil.MAX_CUBIC_AREA
        ,mil.X_COORDINATE
        ,mil.Y_COORDINATE
        ,mil.Z_COORDINATE
        ,mil.INVENTORY_ACCOUNT_ID
        ,mil.SEGMENT1
        ,mil.SEGMENT2
        ,mil.SEGMENT3
        ,mil.SEGMENT4
        ,mil.SEGMENT5
        ,mil.SEGMENT6
        ,mil.SEGMENT7
        ,mil.SEGMENT8
        ,mil.SEGMENT9
        ,mil.SEGMENT10
        ,mil.SEGMENT11
        ,mil.SEGMENT12
        ,mil.SEGMENT13
        ,mil.SEGMENT14
        ,mil.SEGMENT15
        ,mil.SEGMENT16
        ,mil.SEGMENT17
        ,mil.SEGMENT18
        ,mil.SEGMENT19
        ,mil.SEGMENT20
        ,mil.SUMMARY_FLAG
        ,mil.ENABLED_FLAG
        ,mil.START_DATE_ACTIVE
        ,mil.END_DATE_ACTIVE
        ,mil.ATTRIBUTE_CATEGORY
        ,mil.ATTRIBUTE1
        ,mil.ATTRIBUTE2
        ,mil.ATTRIBUTE3
        ,mil.ATTRIBUTE4
        ,mil.ATTRIBUTE5
        ,mil.ATTRIBUTE6
        ,mil.ATTRIBUTE7
        ,mil.ATTRIBUTE8
        ,mil.ATTRIBUTE9
        ,mil.ATTRIBUTE10
        ,mil.ATTRIBUTE11
        ,mil.ATTRIBUTE12
        ,mil.ATTRIBUTE13
        ,mil.ATTRIBUTE14
        ,mil.ATTRIBUTE15
        ,mil.REQUEST_ID
        ,mil.PROGRAM_APPLICATION_ID
        ,mil.PROGRAM_ID
        ,mil.PROGRAM_UPDATE_DATE
        ,mil.PHYSICAL_LOCATION_ID
        ,mil.PICK_UOM_CODE
        ,mil.DIMENSION_UOM_CODE
        ,mil.LENGTH
        ,mil.WIDTH
        ,mil.HEIGHT
        ,mil.LOCATOR_STATUS
        ,mil.STATUS_ID
        ,mil.CURRENT_CUBIC_AREA
        ,mil.AVAILABLE_CUBIC_AREA
        ,mil.CURRENT_WEIGHT
        ,mil.AVAILABLE_WEIGHT
        ,mil.LOCATION_AVAILABLE_UNITS
        ,mil.SUGGESTED_CUBIC_AREA
        ,mil.SUGGESTED_WEIGHT
        ,mil.LOCATION_SUGGESTED_UNITS
        ,mil.rowid
   from MTL_ITEM_LOCATIONS mil
       ,MTL_SECONDARY_INVENTORIES msei
  where mil.organization_id(+) = msei.organization_id
    and mil.subinventory_code(+) = msei.secondary_inventory_name
    and NVL(msei.disable_date, sysdate+1) > sysdate
    and NVL(mil.disable_date, sysdate+1) > sysdate
)base
 where base.ORGANIZATION_ID = g_organization_id
and base.INVENTORY_ITEM_ID = g_inventory_item_id
 and (g_project_id = base.project_id OR base.project_id IS NULL)
 and (g_task_id = base.task_id OR base.task_id IS NULL)
 and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
 and base.subinventory_code = g_subinventory_code
 and base.locator_id = g_locator_id
 order by WMS_Parameter_PVT.GetItemOnHand(
base.ORGANIZATION_ID
,mptdtv.INVENTORY_ITEM_ID
,base.SUBINVENTORY_CODE
,base.LOCATOR_ID
,msi.PRIMARY_UOM_CODE
,mptdtv.TRANSACTION_UOM ) desc
,base.PROJECT_ID
,base.TASK_ID
;

Line: 436


        OPEN p_cursor FOR select base.SUBINVENTORY_CODE
,base.LOCATOR_ID
,base.PROJECT_ID
,base.TASK_ID
 from MTL_SYSTEM_ITEMS msi
,WMS_TRX_DETAILS_TMP_V mptdtv
,(
 select  msei.secondary_inventory_name subinventory_code            -- changed
        ,mil.inventory_location_id locator_id
        ,msei.organization_id organization_id                       -- changed
        ,mil.project_id project_id
        ,mil.task_id task_id
        ,g_inventory_item_id inventory_item_id
        ,mil.location_current_units location_current_units
        ,mil.inventory_item_id locator_inventory_item_id
        ,mil.empty_flag empty_flag
        ,mil.mixed_items_flag mixed_items_flag
        ,mil.LAST_UPDATE_DATE
        ,mil.LAST_UPDATED_BY
        ,mil.CREATION_DATE
        ,mil.CREATED_BY
        ,mil.LAST_UPDATE_LOGIN
        ,mil.DESCRIPTION
        ,mil.DESCRIPTIVE_TEXT
        ,mil.DISABLE_DATE
        ,mil.INVENTORY_LOCATION_TYPE
        ,mil.PICKING_ORDER
        ,mil.PHYSICAL_LOCATION_CODE
        ,mil.LOCATION_MAXIMUM_UNITS
        ,mil.LOCATION_WEIGHT_UOM_CODE
        ,mil.MAX_WEIGHT
        ,mil.VOLUME_UOM_CODE
        ,mil.MAX_CUBIC_AREA
        ,mil.X_COORDINATE
        ,mil.Y_COORDINATE
        ,mil.Z_COORDINATE
        ,mil.INVENTORY_ACCOUNT_ID
        ,mil.SEGMENT1
        ,mil.SEGMENT2
        ,mil.SEGMENT3
        ,mil.SEGMENT4
        ,mil.SEGMENT5
        ,mil.SEGMENT6
        ,mil.SEGMENT7
        ,mil.SEGMENT8
        ,mil.SEGMENT9
        ,mil.SEGMENT10
        ,mil.SEGMENT11
        ,mil.SEGMENT12
        ,mil.SEGMENT13
        ,mil.SEGMENT14
        ,mil.SEGMENT15
        ,mil.SEGMENT16
        ,mil.SEGMENT17
        ,mil.SEGMENT18
        ,mil.SEGMENT19
        ,mil.SEGMENT20
        ,mil.SUMMARY_FLAG
        ,mil.ENABLED_FLAG
        ,mil.START_DATE_ACTIVE
        ,mil.END_DATE_ACTIVE
        ,mil.ATTRIBUTE_CATEGORY
        ,mil.ATTRIBUTE1
        ,mil.ATTRIBUTE2
        ,mil.ATTRIBUTE3
        ,mil.ATTRIBUTE4
        ,mil.ATTRIBUTE5
        ,mil.ATTRIBUTE6
        ,mil.ATTRIBUTE7
        ,mil.ATTRIBUTE8
        ,mil.ATTRIBUTE9
        ,mil.ATTRIBUTE10
        ,mil.ATTRIBUTE11
        ,mil.ATTRIBUTE12
        ,mil.ATTRIBUTE13
        ,mil.ATTRIBUTE14
        ,mil.ATTRIBUTE15
        ,mil.REQUEST_ID
        ,mil.PROGRAM_APPLICATION_ID
        ,mil.PROGRAM_ID
        ,mil.PROGRAM_UPDATE_DATE
        ,mil.PHYSICAL_LOCATION_ID
        ,mil.PICK_UOM_CODE
        ,mil.DIMENSION_UOM_CODE
        ,mil.LENGTH
        ,mil.WIDTH
        ,mil.HEIGHT
        ,mil.LOCATOR_STATUS
        ,mil.STATUS_ID
        ,mil.CURRENT_CUBIC_AREA
        ,mil.AVAILABLE_CUBIC_AREA
        ,mil.CURRENT_WEIGHT
        ,mil.AVAILABLE_WEIGHT
        ,mil.LOCATION_AVAILABLE_UNITS
        ,mil.SUGGESTED_CUBIC_AREA
        ,mil.SUGGESTED_WEIGHT
        ,mil.LOCATION_SUGGESTED_UNITS
  ,mil.rowid
from MTL_ITEM_LOCATIONS mil
       ,MTL_SECONDARY_INVENTORIES msei
       ,MTL_ITEM_SUB_INVENTORIES misi
  where mil.organization_id(+) = msei.organization_id
    and mil.subinventory_code(+) = msei.secondary_inventory_name
    and NVL(msei.disable_date, sysdate+1) > sysdate
    and NVL(mil.disable_date, sysdate+1) > sysdate
    and mil.organization_id = misi.organization_id
    and mil.subinventory_code = misi.secondary_inventory
    and misi.inventory_item_id = g_inventory_item_id
)base
 where base.ORGANIZATION_ID = g_organization_id
and base.INVENTORY_ITEM_ID = g_inventory_item_id
 and (g_project_id = base.project_id OR base.project_id IS NULL)
 and (g_task_id = base.task_id OR base.task_id IS NULL)
 and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
 order by WMS_Parameter_PVT.GetItemOnHand(
base.ORGANIZATION_ID
,mptdtv.INVENTORY_ITEM_ID
,base.SUBINVENTORY_CODE
,base.LOCATOR_ID
,msi.PRIMARY_UOM_CODE
,mptdtv.TRANSACTION_UOM ) desc
,base.PROJECT_ID
,base.TASK_ID
;

Line: 564


         OPEN p_cursor FOR select base.SUBINVENTORY_CODE
,base.LOCATOR_ID
,base.PROJECT_ID
,base.TASK_ID
 from MTL_SYSTEM_ITEMS msi
,WMS_TRX_DETAILS_TMP_V mptdtv
,(
 select  msei.secondary_inventory_name subinventory_code            -- changed
        ,mil.inventory_location_id locator_id
        ,msei.organization_id organization_id                       -- changed
        ,mil.project_id project_id
        ,mil.task_id task_id
        ,g_inventory_item_id inventory_item_id
        ,mil.location_current_units location_current_units
        ,mil.inventory_item_id locator_inventory_item_id
        ,mil.empty_flag empty_flag
        ,mil.mixed_items_flag mixed_items_flag
        ,mil.LAST_UPDATE_DATE
        ,mil.LAST_UPDATED_BY
        ,mil.CREATION_DATE
        ,mil.CREATED_BY
        ,mil.LAST_UPDATE_LOGIN
        ,mil.DESCRIPTION
        ,mil.DESCRIPTIVE_TEXT
        ,mil.DISABLE_DATE
        ,mil.INVENTORY_LOCATION_TYPE
        ,mil.PICKING_ORDER
        ,mil.PHYSICAL_LOCATION_CODE
        ,mil.LOCATION_MAXIMUM_UNITS
        ,mil.LOCATION_WEIGHT_UOM_CODE
        ,mil.MAX_WEIGHT
        ,mil.VOLUME_UOM_CODE
        ,mil.MAX_CUBIC_AREA
        ,mil.X_COORDINATE
        ,mil.Y_COORDINATE
        ,mil.Z_COORDINATE
        ,mil.INVENTORY_ACCOUNT_ID
        ,mil.SEGMENT1
        ,mil.SEGMENT2
        ,mil.SEGMENT3
        ,mil.SEGMENT4
        ,mil.SEGMENT5
        ,mil.SEGMENT6
        ,mil.SEGMENT7
        ,mil.SEGMENT8
        ,mil.SEGMENT9
        ,mil.SEGMENT10
        ,mil.SEGMENT11
        ,mil.SEGMENT12
        ,mil.SEGMENT13
        ,mil.SEGMENT14
        ,mil.SEGMENT15
        ,mil.SEGMENT16
        ,mil.SEGMENT17
        ,mil.SEGMENT18
        ,mil.SEGMENT19
        ,mil.SEGMENT20
        ,mil.SUMMARY_FLAG
        ,mil.ENABLED_FLAG
        ,mil.START_DATE_ACTIVE
        ,mil.END_DATE_ACTIVE
        ,mil.ATTRIBUTE_CATEGORY
        ,mil.ATTRIBUTE1
        ,mil.ATTRIBUTE2
        ,mil.ATTRIBUTE3
        ,mil.ATTRIBUTE4
        ,mil.ATTRIBUTE5
        ,mil.ATTRIBUTE6
        ,mil.ATTRIBUTE7
        ,mil.ATTRIBUTE8
        ,mil.ATTRIBUTE9
        ,mil.ATTRIBUTE10
        ,mil.ATTRIBUTE11
        ,mil.ATTRIBUTE12
        ,mil.ATTRIBUTE13
        ,mil.ATTRIBUTE14
        ,mil.ATTRIBUTE15
        ,mil.REQUEST_ID
        ,mil.PROGRAM_APPLICATION_ID
        ,mil.PROGRAM_ID
        ,mil.PROGRAM_UPDATE_DATE
        ,mil.PHYSICAL_LOCATION_ID
        ,mil.PICK_UOM_CODE
        ,mil.DIMENSION_UOM_CODE
        ,mil.LENGTH
        ,mil.WIDTH
        ,mil.HEIGHT
        ,mil.LOCATOR_STATUS
        ,mil.STATUS_ID
        ,mil.CURRENT_CUBIC_AREA
        ,mil.AVAILABLE_CUBIC_AREA
        ,mil.CURRENT_WEIGHT
        ,mil.AVAILABLE_WEIGHT
        ,mil.LOCATION_AVAILABLE_UNITS
        ,mil.SUGGESTED_CUBIC_AREA
        ,mil.SUGGESTED_WEIGHT
        ,mil.LOCATION_SUGGESTED_UNITS
  ,mil.rowid
from MTL_ITEM_LOCATIONS mil
       ,MTL_SECONDARY_INVENTORIES msei
       ,MTL_ITEM_SUB_INVENTORIES misi
  where mil.organization_id(+) = msei.organization_id
    and mil.subinventory_code(+) = msei.secondary_inventory_name
    and NVL(msei.disable_date, sysdate+1) > sysdate
    and NVL(mil.disable_date, sysdate+1) > sysdate
    and mil.organization_id = misi.organization_id
    and mil.subinventory_code = misi.secondary_inventory
    and misi.inventory_item_id = g_inventory_item_id
)base
 where base.ORGANIZATION_ID = g_organization_id
and base.INVENTORY_ITEM_ID = g_inventory_item_id
 and (g_project_id = base.project_id OR base.project_id IS NULL)
 and (g_task_id = base.task_id OR base.task_id IS NULL)
 and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
 and base.subinventory_code = g_subinventory_code
 order by WMS_Parameter_PVT.GetItemOnHand(
base.ORGANIZATION_ID
,mptdtv.INVENTORY_ITEM_ID
,base.SUBINVENTORY_CODE
,base.LOCATOR_ID
,msi.PRIMARY_UOM_CODE
,mptdtv.TRANSACTION_UOM ) desc
,base.PROJECT_ID
,base.TASK_ID
;

Line: 694


        OPEN p_cursor FOR select base.SUBINVENTORY_CODE
,base.LOCATOR_ID
,base.PROJECT_ID
,base.TASK_ID
 from MTL_SYSTEM_ITEMS msi
,WMS_TRX_DETAILS_TMP_V mptdtv
,(
 select  msei.secondary_inventory_name subinventory_code            -- changed
        ,mil.inventory_location_id locator_id
        ,msei.organization_id organization_id                       -- changed
        ,mil.project_id project_id
        ,mil.task_id task_id
        ,g_inventory_item_id inventory_item_id
        ,mil.location_current_units location_current_units
        ,mil.inventory_item_id locator_inventory_item_id
        ,mil.empty_flag empty_flag
        ,mil.mixed_items_flag mixed_items_flag
        ,mil.LAST_UPDATE_DATE
        ,mil.LAST_UPDATED_BY
        ,mil.CREATION_DATE
        ,mil.CREATED_BY
        ,mil.LAST_UPDATE_LOGIN
        ,mil.DESCRIPTION
        ,mil.DESCRIPTIVE_TEXT
        ,mil.DISABLE_DATE
        ,mil.INVENTORY_LOCATION_TYPE
        ,mil.PICKING_ORDER
        ,mil.PHYSICAL_LOCATION_CODE
        ,mil.LOCATION_MAXIMUM_UNITS
        ,mil.LOCATION_WEIGHT_UOM_CODE
        ,mil.MAX_WEIGHT
        ,mil.VOLUME_UOM_CODE
        ,mil.MAX_CUBIC_AREA
        ,mil.X_COORDINATE
        ,mil.Y_COORDINATE
        ,mil.Z_COORDINATE
        ,mil.INVENTORY_ACCOUNT_ID
        ,mil.SEGMENT1
        ,mil.SEGMENT2
        ,mil.SEGMENT3
        ,mil.SEGMENT4
        ,mil.SEGMENT5
        ,mil.SEGMENT6
        ,mil.SEGMENT7
        ,mil.SEGMENT8
        ,mil.SEGMENT9
        ,mil.SEGMENT10
        ,mil.SEGMENT11
        ,mil.SEGMENT12
        ,mil.SEGMENT13
        ,mil.SEGMENT14
        ,mil.SEGMENT15
        ,mil.SEGMENT16
        ,mil.SEGMENT17
        ,mil.SEGMENT18
        ,mil.SEGMENT19
        ,mil.SEGMENT20
        ,mil.SUMMARY_FLAG
        ,mil.ENABLED_FLAG
        ,mil.START_DATE_ACTIVE
        ,mil.END_DATE_ACTIVE
        ,mil.ATTRIBUTE_CATEGORY
        ,mil.ATTRIBUTE1
        ,mil.ATTRIBUTE2
        ,mil.ATTRIBUTE3
        ,mil.ATTRIBUTE4
        ,mil.ATTRIBUTE5
        ,mil.ATTRIBUTE6
        ,mil.ATTRIBUTE7
        ,mil.ATTRIBUTE8
        ,mil.ATTRIBUTE9
        ,mil.ATTRIBUTE10
        ,mil.ATTRIBUTE11
        ,mil.ATTRIBUTE12
        ,mil.ATTRIBUTE13
        ,mil.ATTRIBUTE14
        ,mil.ATTRIBUTE15
        ,mil.REQUEST_ID
        ,mil.PROGRAM_APPLICATION_ID
        ,mil.PROGRAM_ID
        ,mil.PROGRAM_UPDATE_DATE
        ,mil.PHYSICAL_LOCATION_ID
        ,mil.PICK_UOM_CODE
        ,mil.DIMENSION_UOM_CODE
        ,mil.LENGTH
        ,mil.WIDTH
        ,mil.HEIGHT
        ,mil.LOCATOR_STATUS
        ,mil.STATUS_ID
        ,mil.CURRENT_CUBIC_AREA
        ,mil.AVAILABLE_CUBIC_AREA
        ,mil.CURRENT_WEIGHT
        ,mil.AVAILABLE_WEIGHT
        ,mil.LOCATION_AVAILABLE_UNITS
        ,mil.SUGGESTED_CUBIC_AREA
        ,mil.SUGGESTED_WEIGHT
        ,mil.LOCATION_SUGGESTED_UNITS
  ,mil.rowid
from MTL_ITEM_LOCATIONS mil
       ,MTL_SECONDARY_INVENTORIES msei
       ,MTL_ITEM_SUB_INVENTORIES misi
  where mil.organization_id(+) = msei.organization_id
    and mil.subinventory_code(+) = msei.secondary_inventory_name
    and NVL(msei.disable_date, sysdate+1) > sysdate
    and NVL(mil.disable_date, sysdate+1) > sysdate
    and mil.organization_id = misi.organization_id
    and mil.subinventory_code = misi.secondary_inventory
    and misi.inventory_item_id = g_inventory_item_id
)base
 where base.ORGANIZATION_ID = g_organization_id
and base.INVENTORY_ITEM_ID = g_inventory_item_id
 and (g_project_id = base.project_id OR base.project_id IS NULL)
 and (g_task_id = base.task_id OR base.task_id IS NULL)
 and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
 and base.subinventory_code = g_subinventory_code
 and base.locator_id = g_locator_id
 order by WMS_Parameter_PVT.GetItemOnHand(
base.ORGANIZATION_ID
,mptdtv.INVENTORY_ITEM_ID
,base.SUBINVENTORY_CODE
,base.LOCATOR_ID
,msi.PRIMARY_UOM_CODE
,mptdtv.TRANSACTION_UOM ) desc
,base.PROJECT_ID
,base.TASK_ID
;

Line: 826


        OPEN p_cursor FOR select base.SUBINVENTORY_CODE
,base.LOCATOR_ID
,base.PROJECT_ID
,base.TASK_ID
 from MTL_SYSTEM_ITEMS msi
,WMS_TRX_DETAILS_TMP_V mptdtv
,(
 select  mil.subinventory_code subinventory_code
        ,mil.inventory_location_id locator_id
        ,mil.organization_id organization_id
        ,mil.project_id project_id
        ,mil.task_id task_id
        ,g_inventory_item_id inventory_item_id
        ,mil.location_current_units location_current_units
        ,mil.inventory_item_id locator_inventory_item_id
        ,mil.empty_flag empty_flag
        ,mil.mixed_items_flag mixed_items_flag
        ,mil.LAST_UPDATE_DATE
        ,mil.LAST_UPDATED_BY
        ,mil.CREATION_DATE
        ,mil.CREATED_BY
        ,mil.LAST_UPDATE_LOGIN
        ,mil.DESCRIPTION
        ,mil.DESCRIPTIVE_TEXT
        ,mil.DISABLE_DATE
        ,mil.INVENTORY_LOCATION_TYPE
        ,mil.PICKING_ORDER
        ,mil.PHYSICAL_LOCATION_CODE
        ,mil.LOCATION_MAXIMUM_UNITS
        ,mil.LOCATION_WEIGHT_UOM_CODE
        ,mil.MAX_WEIGHT
        ,mil.VOLUME_UOM_CODE
        ,mil.MAX_CUBIC_AREA
        ,mil.X_COORDINATE
        ,mil.Y_COORDINATE
        ,mil.Z_COORDINATE
        ,mil.INVENTORY_ACCOUNT_ID
        ,mil.SEGMENT1
        ,mil.SEGMENT2
        ,mil.SEGMENT3
        ,mil.SEGMENT4
        ,mil.SEGMENT5
        ,mil.SEGMENT6
        ,mil.SEGMENT7
        ,mil.SEGMENT8
        ,mil.SEGMENT9
        ,mil.SEGMENT10
        ,mil.SEGMENT11
        ,mil.SEGMENT12
        ,mil.SEGMENT13
        ,mil.SEGMENT14
        ,mil.SEGMENT15
        ,mil.SEGMENT16
        ,mil.SEGMENT17
        ,mil.SEGMENT18
        ,mil.SEGMENT19
        ,mil.SEGMENT20
        ,mil.SUMMARY_FLAG
        ,mil.ENABLED_FLAG
        ,mil.START_DATE_ACTIVE
        ,mil.END_DATE_ACTIVE
        ,mil.ATTRIBUTE_CATEGORY
        ,mil.ATTRIBUTE1
        ,mil.ATTRIBUTE2
        ,mil.ATTRIBUTE3
        ,mil.ATTRIBUTE4
        ,mil.ATTRIBUTE5
        ,mil.ATTRIBUTE6
        ,mil.ATTRIBUTE7
        ,mil.ATTRIBUTE8
        ,mil.ATTRIBUTE9
        ,mil.ATTRIBUTE10
        ,mil.ATTRIBUTE11
        ,mil.ATTRIBUTE12
        ,mil.ATTRIBUTE13
        ,mil.ATTRIBUTE14
        ,mil.ATTRIBUTE15
        ,mil.REQUEST_ID
        ,mil.PROGRAM_APPLICATION_ID
        ,mil.PROGRAM_ID
        ,mil.PROGRAM_UPDATE_DATE
        ,mil.PHYSICAL_LOCATION_ID
        ,mil.PICK_UOM_CODE
        ,mil.DIMENSION_UOM_CODE
        ,mil.LENGTH
        ,mil.WIDTH
        ,mil.HEIGHT
        ,mil.LOCATOR_STATUS
        ,mil.STATUS_ID
        ,mil.CURRENT_CUBIC_AREA
        ,mil.AVAILABLE_CUBIC_AREA
        ,mil.CURRENT_WEIGHT
        ,mil.AVAILABLE_WEIGHT
        ,mil.LOCATION_AVAILABLE_UNITS
        ,mil.SUGGESTED_CUBIC_AREA
        ,mil.SUGGESTED_WEIGHT
        ,mil.LOCATION_SUGGESTED_UNITS
        ,mil.rowid
   from MTL_ITEM_LOCATIONS mil
       ,MTL_SECONDARY_INVENTORIES msei
       ,MTL_ITEM_SUB_INVENTORIES misi
       ,MTL_SECONDARY_LOCATORS msl
  where mil.organization_id = msei.organization_id
    and mil.subinventory_code = msei.secondary_inventory_name
    and NVL(msei.disable_date, sysdate+1) > sysdate
    and NVL(mil.disable_date, sysdate+1) > sysdate
    and mil.organization_id = misi.organization_id
    and mil.subinventory_code = misi.secondary_inventory
    and misi.inventory_item_id = g_inventory_item_id
    and mil.organization_id = msl.organization_id
    and mil.inventory_location_id = msl.secondary_locator
    and msl.inventory_item_Id = g_inventory_item_id
)base
 where base.ORGANIZATION_ID = g_organization_id
and base.INVENTORY_ITEM_ID = g_inventory_item_id
 and (g_project_id = base.project_id OR base.project_id IS NULL)
 and (g_task_id = base.task_id OR base.task_id IS NULL)
 and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
 order by WMS_Parameter_PVT.GetItemOnHand(
base.ORGANIZATION_ID
,mptdtv.INVENTORY_ITEM_ID
,base.SUBINVENTORY_CODE
,base.LOCATOR_ID
,msi.PRIMARY_UOM_CODE
,mptdtv.TRANSACTION_UOM ) desc
,base.PROJECT_ID
,base.TASK_ID
;

Line: 959


        OPEN p_cursor FOR select base.SUBINVENTORY_CODE
,base.LOCATOR_ID
,base.PROJECT_ID
,base.TASK_ID
 from MTL_SYSTEM_ITEMS msi
,WMS_TRX_DETAILS_TMP_V mptdtv
,(
 select  mil.subinventory_code subinventory_code
        ,mil.inventory_location_id locator_id
        ,mil.organization_id organization_id
        ,mil.project_id project_id
        ,mil.task_id task_id
        ,g_inventory_item_id inventory_item_id
        ,mil.location_current_units location_current_units
        ,mil.inventory_item_id locator_inventory_item_id
        ,mil.empty_flag empty_flag
        ,mil.mixed_items_flag mixed_items_flag
        ,mil.LAST_UPDATE_DATE
        ,mil.LAST_UPDATED_BY
        ,mil.CREATION_DATE
        ,mil.CREATED_BY
        ,mil.LAST_UPDATE_LOGIN
        ,mil.DESCRIPTION
        ,mil.DESCRIPTIVE_TEXT
        ,mil.DISABLE_DATE
        ,mil.INVENTORY_LOCATION_TYPE
        ,mil.PICKING_ORDER
        ,mil.PHYSICAL_LOCATION_CODE
        ,mil.LOCATION_MAXIMUM_UNITS
        ,mil.LOCATION_WEIGHT_UOM_CODE
        ,mil.MAX_WEIGHT
        ,mil.VOLUME_UOM_CODE
        ,mil.MAX_CUBIC_AREA
        ,mil.X_COORDINATE
        ,mil.Y_COORDINATE
        ,mil.Z_COORDINATE
        ,mil.INVENTORY_ACCOUNT_ID
        ,mil.SEGMENT1
        ,mil.SEGMENT2
        ,mil.SEGMENT3
        ,mil.SEGMENT4
        ,mil.SEGMENT5
        ,mil.SEGMENT6
        ,mil.SEGMENT7
        ,mil.SEGMENT8
        ,mil.SEGMENT9
        ,mil.SEGMENT10
        ,mil.SEGMENT11
        ,mil.SEGMENT12
        ,mil.SEGMENT13
        ,mil.SEGMENT14
        ,mil.SEGMENT15
        ,mil.SEGMENT16
        ,mil.SEGMENT17
        ,mil.SEGMENT18
        ,mil.SEGMENT19
        ,mil.SEGMENT20
        ,mil.SUMMARY_FLAG
        ,mil.ENABLED_FLAG
        ,mil.START_DATE_ACTIVE
        ,mil.END_DATE_ACTIVE
        ,mil.ATTRIBUTE_CATEGORY
        ,mil.ATTRIBUTE1
        ,mil.ATTRIBUTE2
        ,mil.ATTRIBUTE3
        ,mil.ATTRIBUTE4
        ,mil.ATTRIBUTE5
        ,mil.ATTRIBUTE6
        ,mil.ATTRIBUTE7
        ,mil.ATTRIBUTE8
        ,mil.ATTRIBUTE9
        ,mil.ATTRIBUTE10
        ,mil.ATTRIBUTE11
        ,mil.ATTRIBUTE12
        ,mil.ATTRIBUTE13
        ,mil.ATTRIBUTE14
        ,mil.ATTRIBUTE15
        ,mil.REQUEST_ID
        ,mil.PROGRAM_APPLICATION_ID
        ,mil.PROGRAM_ID
        ,mil.PROGRAM_UPDATE_DATE
        ,mil.PHYSICAL_LOCATION_ID
        ,mil.PICK_UOM_CODE
        ,mil.DIMENSION_UOM_CODE
        ,mil.LENGTH
        ,mil.WIDTH
        ,mil.HEIGHT
        ,mil.LOCATOR_STATUS
        ,mil.STATUS_ID
        ,mil.CURRENT_CUBIC_AREA
        ,mil.AVAILABLE_CUBIC_AREA
        ,mil.CURRENT_WEIGHT
        ,mil.AVAILABLE_WEIGHT
        ,mil.LOCATION_AVAILABLE_UNITS
        ,mil.SUGGESTED_CUBIC_AREA
        ,mil.SUGGESTED_WEIGHT
        ,mil.LOCATION_SUGGESTED_UNITS
        ,mil.rowid
   from MTL_ITEM_LOCATIONS mil
       ,MTL_SECONDARY_INVENTORIES msei
       ,MTL_ITEM_SUB_INVENTORIES misi
       ,MTL_SECONDARY_LOCATORS msl
  where mil.organization_id = msei.organization_id
    and mil.subinventory_code = msei.secondary_inventory_name
    and NVL(msei.disable_date, sysdate+1) > sysdate
    and NVL(mil.disable_date, sysdate+1) > sysdate
    and mil.organization_id = misi.organization_id
    and mil.subinventory_code = misi.secondary_inventory
    and misi.inventory_item_id = g_inventory_item_id
    and mil.organization_id = msl.organization_id
    and mil.inventory_location_id = msl.secondary_locator
    and msl.inventory_item_Id = g_inventory_item_id
)base
 where base.ORGANIZATION_ID = g_organization_id
and base.INVENTORY_ITEM_ID = g_inventory_item_id
 and (g_project_id = base.project_id OR base.project_id IS NULL)
 and (g_task_id = base.task_id OR base.task_id IS NULL)
 and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
 and base.subinventory_code = g_subinventory_code
 order by WMS_Parameter_PVT.GetItemOnHand(
base.ORGANIZATION_ID
,mptdtv.INVENTORY_ITEM_ID
,base.SUBINVENTORY_CODE
,base.LOCATOR_ID
,msi.PRIMARY_UOM_CODE
,mptdtv.TRANSACTION_UOM ) desc
,base.PROJECT_ID
,base.TASK_ID
;

Line: 1093


        OPEN p_cursor FOR select base.SUBINVENTORY_CODE
,base.LOCATOR_ID
,base.PROJECT_ID
,base.TASK_ID
 from MTL_SYSTEM_ITEMS msi
,WMS_TRX_DETAILS_TMP_V mptdtv
,(
 select  mil.subinventory_code subinventory_code
        ,mil.inventory_location_id locator_id
        ,mil.organization_id organization_id
        ,mil.project_id project_id
        ,mil.task_id task_id
        ,g_inventory_item_id inventory_item_id
        ,mil.location_current_units location_current_units
        ,mil.inventory_item_id locator_inventory_item_id
        ,mil.empty_flag empty_flag
        ,mil.mixed_items_flag mixed_items_flag
        ,mil.LAST_UPDATE_DATE
        ,mil.LAST_UPDATED_BY
        ,mil.CREATION_DATE
        ,mil.CREATED_BY
        ,mil.LAST_UPDATE_LOGIN
        ,mil.DESCRIPTION
        ,mil.DESCRIPTIVE_TEXT
        ,mil.DISABLE_DATE
        ,mil.INVENTORY_LOCATION_TYPE
        ,mil.PICKING_ORDER
        ,mil.PHYSICAL_LOCATION_CODE
        ,mil.LOCATION_MAXIMUM_UNITS
        ,mil.LOCATION_WEIGHT_UOM_CODE
        ,mil.MAX_WEIGHT
        ,mil.VOLUME_UOM_CODE
        ,mil.MAX_CUBIC_AREA
        ,mil.X_COORDINATE
        ,mil.Y_COORDINATE
        ,mil.Z_COORDINATE
        ,mil.INVENTORY_ACCOUNT_ID
        ,mil.SEGMENT1
        ,mil.SEGMENT2
        ,mil.SEGMENT3
        ,mil.SEGMENT4
        ,mil.SEGMENT5
        ,mil.SEGMENT6
        ,mil.SEGMENT7
        ,mil.SEGMENT8
        ,mil.SEGMENT9
        ,mil.SEGMENT10
        ,mil.SEGMENT11
        ,mil.SEGMENT12
        ,mil.SEGMENT13
        ,mil.SEGMENT14
        ,mil.SEGMENT15
        ,mil.SEGMENT16
        ,mil.SEGMENT17
        ,mil.SEGMENT18
        ,mil.SEGMENT19
        ,mil.SEGMENT20
        ,mil.SUMMARY_FLAG
        ,mil.ENABLED_FLAG
        ,mil.START_DATE_ACTIVE
        ,mil.END_DATE_ACTIVE
        ,mil.ATTRIBUTE_CATEGORY
        ,mil.ATTRIBUTE1
        ,mil.ATTRIBUTE2
        ,mil.ATTRIBUTE3
        ,mil.ATTRIBUTE4
        ,mil.ATTRIBUTE5
        ,mil.ATTRIBUTE6
        ,mil.ATTRIBUTE7
        ,mil.ATTRIBUTE8
        ,mil.ATTRIBUTE9
        ,mil.ATTRIBUTE10
        ,mil.ATTRIBUTE11
        ,mil.ATTRIBUTE12
        ,mil.ATTRIBUTE13
        ,mil.ATTRIBUTE14
        ,mil.ATTRIBUTE15
        ,mil.REQUEST_ID
        ,mil.PROGRAM_APPLICATION_ID
        ,mil.PROGRAM_ID
        ,mil.PROGRAM_UPDATE_DATE
        ,mil.PHYSICAL_LOCATION_ID
        ,mil.PICK_UOM_CODE
        ,mil.DIMENSION_UOM_CODE
        ,mil.LENGTH
        ,mil.WIDTH
        ,mil.HEIGHT
        ,mil.LOCATOR_STATUS
        ,mil.STATUS_ID
        ,mil.CURRENT_CUBIC_AREA
        ,mil.AVAILABLE_CUBIC_AREA
        ,mil.CURRENT_WEIGHT
        ,mil.AVAILABLE_WEIGHT
        ,mil.LOCATION_AVAILABLE_UNITS
        ,mil.SUGGESTED_CUBIC_AREA
        ,mil.SUGGESTED_WEIGHT
        ,mil.LOCATION_SUGGESTED_UNITS
        ,mil.rowid
   from MTL_ITEM_LOCATIONS mil
       ,MTL_SECONDARY_INVENTORIES msei
       ,MTL_ITEM_SUB_INVENTORIES misi
       ,MTL_SECONDARY_LOCATORS msl
  where mil.organization_id = msei.organization_id
    and mil.subinventory_code = msei.secondary_inventory_name
    and NVL(msei.disable_date, sysdate+1) > sysdate
    and NVL(mil.disable_date, sysdate+1) > sysdate
    and mil.organization_id = misi.organization_id
    and mil.subinventory_code = misi.secondary_inventory
    and misi.inventory_item_id = g_inventory_item_id
    and mil.organization_id = msl.organization_id
    and mil.inventory_location_id = msl.secondary_locator
    and msl.inventory_item_Id = g_inventory_item_id
)base
 where base.ORGANIZATION_ID = g_organization_id
and base.INVENTORY_ITEM_ID = g_inventory_item_id
 and (g_project_id = base.project_id OR base.project_id IS NULL)
 and (g_task_id = base.task_id OR base.task_id IS NULL)
 and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
 and base.subinventory_code = g_subinventory_code
 and base.locator_id = g_locator_id
 order by WMS_Parameter_PVT.GetItemOnHand(
base.ORGANIZATION_ID
,mptdtv.INVENTORY_ITEM_ID
,base.SUBINVENTORY_CODE
,base.LOCATOR_ID
,msi.PRIMARY_UOM_CODE
,mptdtv.TRANSACTION_UOM ) desc
,base.PROJECT_ID
,base.TASK_ID
;