DBA Data[Home] [Help]

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: --Bugfix 11056452
494: lCnt number;
495:

Line 1274: FROM mtl_system_items_vl item

1270:
1271: BEGIN
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

Line 1387: FROM mtl_system_items_vl item

1383:
1384: BEGIN
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