DBA Data[Home] [Help]

APPS.CTO_CHANGE_ORDER_PK dependencies on MTL_PLANNERS

Line 1410: mtl_planners p,

1406: -- Introdcued this to get a unique user name
1407: CURSOR get_planner_user_name(inv_item_id NUMBER,ship_org_id NUMBER) IS
1408: SELECT u.user_name
1409: FROM mtl_system_items_vl item,
1410: mtl_planners p,
1411: fnd_user u
1412: WHERE item.inventory_item_id = inv_item_id
1413: and item.organization_id = ship_org_id
1414: and p.organization_id = item.organization_id

Line 1650: ,mtl_planners p

1646: -- getting the value for user_name in the variable.
1647: /*SELECT u.user_name
1648: INTO lplanner_code
1649: FROM mtl_system_items_vl item
1650: ,mtl_planners p
1651: ,fnd_user u
1652: WHERE item.inventory_item_id = linv_item_id
1653: and item.organization_id = lship_org_id
1654: and p.organization_id = item.organization_id