DBA Data[Home] [Help]

APPS.CTO_BOM_RTG_PK dependencies on FND_USER

Line 1276: ,fnd_user u

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

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

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

Line 1389: ,fnd_user u

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

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

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