475: ,moq.lpn_id lpn_id
476: ,decode(mils.project_id, mils.project_id, moq.project_id) project_id
477: ,decode(mils.task_id, mils.task_id, moq.task_id) task_id
478: FROM
479: mtl_onhand_quantities_detail moq,mtl_item_locations mils
480: WHERE
481: moq.organization_id = g_organization_id
482: AND moq.inventory_item_id = g_inventory_item_id
483: AND moq.organization_id = mils.organization_id (+)