APPS.CTO_BOM_RTG_PK dependencies on MTL_SYSTEM_ITEMS_VL

Line 491: lplanner_code mtl_system_items_vl.planner_code%type;

487: v_problem_model_line_num varchar2(1000) ;
488: v_table_count number ;
489: v_error_org varchar2(1000) ;
490: v_recipient varchar2(100) ;
491: lplanner_code mtl_system_items_vl.planner_code%type;
492:
493: BEGIN
494:
495: xReturnStatus := fnd_api.g_ret_sts_success;

Line 1271: FROM mtl_system_items_vl item

1267:
1268: BEGIN
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

Line 1384: FROM mtl_system_items_vl item

1380:
1381: BEGIN
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