APPS.CTO_CONFIG_BOM_PK dependencies on FND_USER

Line 1704: ,fnd_user u

1700: SELECT u.user_name
1701: INTO lplanner_code
1702: FROM mtl_system_items_vl item
1703: ,mtl_planners p
1704: ,fnd_user u
1705: WHERE item.inventory_item_id = pModelId
1706: and item.organization_id = pOrgId
1707: and p.organization_id = item.organization_id
1708: and p.planner_code = item.planner_code

Line 1709: and p.employee_id = u.employee_id(+); --outer join b'cos employee need not be an fnd user.

1705: WHERE item.inventory_item_id = pModelId
1706: and item.organization_id = pOrgId
1707: and p.organization_id = item.organization_id
1708: and p.planner_code = item.planner_code
1709: and p.employee_id = u.employee_id(+); --outer join b'cos employee need not be an fnd user.
1710:
1711:
1712: oe_debug_pub.add('create_bom_ml: ' || '****PLANNER CODE DATA' || lplanner_code ,2);
1713:

Line 1845: ,fnd_user u

1841: SELECT u.user_name
1842: INTO lplanner_code
1843: FROM mtl_system_items_vl item
1844: ,mtl_planners p
1845: ,fnd_user u
1846: WHERE item.inventory_item_id = pModelId
1847: and item.organization_id = pOrgId
1848: and p.organization_id = item.organization_id
1849: and p.planner_code = item.planner_code

Line 1850: and p.employee_id = u.employee_id(+); --outer join b'cos employee need not be an fnd user.

1846: WHERE item.inventory_item_id = pModelId
1847: and item.organization_id = pOrgId
1848: and p.organization_id = item.organization_id
1849: and p.planner_code = item.planner_code
1850: and p.employee_id = u.employee_id(+); --outer join b'cos employee need not be an fnd user.
1851:
1852:
1853: oe_debug_pub.add('create_bom_ml: ' || '****PLANNER CODE DATA' || lplanner_code ,2);
1854: