DBA Data[Home] [Help]

APPS.PJM_BORROW_PAYBACK dependencies on MTL_ITEM_LOCATIONS

Line 470: from mtl_item_locations

466: select project_id, task_id,
467: physical_location_id
468: into l_from_project_id, l_from_task_id,
469: l_from_physical_loc
470: from mtl_item_locations
471: where organization_id = X_Organization_Id
472: and inventory_location_id = X_From_Locator_Id ;
473:
474: else

Line 488: from mtl_item_locations

484: select project_id, task_id,
485: physical_location_id
486: into l_to_project_id, l_to_task_id,
487: l_to_physical_loc
488: from mtl_item_locations
489: where organization_id = X_Organization_Id
490: and inventory_location_id = X_To_Locator_Id;
491:
492:

Line 617: mtl_item_locations mil

613: BEGIN
614: select sum(moq.transaction_quantity)
615: into l_onhand_qty
616: from mtl_onhand_quantities_detail moq,
617: mtl_item_locations mil
618: where mil.project_id = l_from_project_id
619: and mil.task_id = l_from_task_id
620: and mil.subinventory_code = X_From_Subinventory
621: and mil.organization_id = X_Organization_Id