Planner code table in oracle apps

Planner code table in oracle apps

In this post , We will be discuss about the Planner code table in oracle apps. We do create the Planner in Oracle Inventory. Planner code table helps to store the Inventory Planner information in oracle apps.We will get the information about the Employees which are working as a planner in oracle apps. Here below is the detail information about planner code table in oracle apps.

 3 Most Important Planner code table in oracle apps

1.MTL_PLANNERS

2.PER_ALL_PEOPLE_F

3.MTL_SYSTEM_ITEMS_B

SQL Query using Planner code table in oracle apps

select planner_code,organization_id,description,electronic_mail_address,MP.employee_id,PAPF.FULL_NAME from apps.MTL_PLANNERS MP,PER_ALL_PEOPLE_F  PAPF
where organization_id=:P_ORG_ID
AND MP.EMPLOYEE_ID=PAPF.PERSON_ID
AND PAPF.EFFECTIVE_END_DATE>=SYSDATE


SELECT MSBI.SEGMENT1 ITEM_CODE,MSBI.DESCRIPTION ITEM_DESCRIPTION,MSBI.PLANNER_CODE,
MSBI.organization_id,MP.description,MP.electronic_mail_address,MP.employee_id,PAPF.FULL_NAME
FROM APPS.MTL_SYSTEM_ITEMS_B MSBI,apps.MTL_PLANNERS MP,apps.PER_ALL_PEOPLE_F  PAPF
WHERE MSBI.PLANNER_CODE='Test Plner'
AND MSBI.PLANNER_CODE=MP.PLANNER_CODE
AND MSBI.organization_id=MP.organization_id
AND MSBI.organization_id=:P_ORG_ID