APPS.CTO_BOM_RTG_PK dependencies on FND_USER

Line 1273: ,fnd_user u

1269: SELECT u.user_name
1270: INTO lplanner_code
1271: FROM mtl_system_items_vl item
1272: ,mtl_planners p
1273: ,fnd_user u
1274: WHERE item.inventory_item_id = pModelId
1275: and item.organization_id = lNextRec.organization_id
1276: and p.organization_id = item.organization_id
1277: and p.planner_code = item.planner_code

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

1274: WHERE item.inventory_item_id = pModelId
1275: and item.organization_id = lNextRec.organization_id
1276: and p.organization_id = item.organization_id
1277: and p.planner_code = item.planner_code
1278: and p.employee_id = u.employee_id(+); --outer join b'cos employee need not be an fnd user.
1279: oe_debug_pub.add('create_bom_ml: ' || '****PLANNER CODE DATA' || lplanner_code ,2);
1280: EXCEPTION
1281: WHEN OTHERS THEN
1282: IF PG_DEBUG <> 0 THEN

Line 1386: ,fnd_user u

1382: SELECT u.user_name
1383: INTO lplanner_code
1384: FROM mtl_system_items_vl item
1385: ,mtl_planners p
1386: ,fnd_user u
1387: WHERE item.inventory_item_id = pModelId
1388: and item.organization_id = lNextRec.organization_id
1389: and p.organization_id = item.organization_id
1390: and p.planner_code = item.planner_code

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

1387: WHERE item.inventory_item_id = pModelId
1388: and item.organization_id = lNextRec.organization_id
1389: and p.organization_id = item.organization_id
1390: and p.planner_code = item.planner_code
1391: and p.employee_id = u.employee_id(+); --outer join b'cos employee need not be an fnd user.
1392:
1393:
1394: oe_debug_pub.add('create_bom_ml: ' || '****PLANNER CODE DATA' || lplanner_code ,2);
1395: