DBA Data[Home] [Help]

APPS.WMS_RULE_17 dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 454: mtl_onhand_quantities_detail moq,mtl_item_locations mils

450: ,moq.lpn_id lpn_id
451: ,decode(mils.project_id, mils.project_id, moq.project_id) project_id
452: ,decode(mils.task_id, mils.task_id, moq.task_id) task_id
453: FROM
454: mtl_onhand_quantities_detail moq,mtl_item_locations mils
455: WHERE
456: moq.organization_id = g_organization_id
457: AND moq.inventory_item_id = g_inventory_item_id
458: AND moq.organization_id = mils.organization_id (+)