APPS.CTO_CONFIG_BOM_PK dependencies on FND_USER

Line 1678: ,fnd_user u

1674: SELECT u.user_name
1675: INTO lplanner_code
1676: FROM mtl_system_items_vl item
1677: ,mtl_planners p
1678: ,fnd_user u
1679: WHERE item.inventory_item_id = pModelId
1680: and item.organization_id = pOrgId
1681: and p.organization_id = item.organization_id
1682: and p.planner_code = item.planner_code

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

1679: WHERE item.inventory_item_id = pModelId
1680: and item.organization_id = pOrgId
1681: and p.organization_id = item.organization_id
1682: and p.planner_code = item.planner_code
1683: and p.employee_id = u.employee_id(+); --outer join b'cos employee need not be an fnd user.
1684:
1685:
1686: oe_debug_pub.add('create_bom_ml: ' || '****PLANNER CODE DATA' || lplanner_code ,2);
1687:

Line 1819: ,fnd_user u

1815: SELECT u.user_name
1816: INTO lplanner_code
1817: FROM mtl_system_items_vl item
1818: ,mtl_planners p
1819: ,fnd_user u
1820: WHERE item.inventory_item_id = pModelId
1821: and item.organization_id = pOrgId
1822: and p.organization_id = item.organization_id
1823: and p.planner_code = item.planner_code

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

1820: WHERE item.inventory_item_id = pModelId
1821: and item.organization_id = pOrgId
1822: and p.organization_id = item.organization_id
1823: and p.planner_code = item.planner_code
1824: and p.employee_id = u.employee_id(+); --outer join b'cos employee need not be an fnd user.
1825:
1826:
1827: oe_debug_pub.add('create_bom_ml: ' || '****PLANNER CODE DATA' || lplanner_code ,2);
1828: