APPS.CTO_CONFIG_BOM_PK dependencies on MTL_SYSTEM_ITEMS_VL

Line 304: lplanner_code mtl_system_items_vl.planner_code%type;

300: l_anumvalue wf_engine.numtabtyp;
301: l_atxtvalue wf_engine.texttabtyp;
302: luser_key varchar2(100);
303: litem_key varchar2(100);
304: lplanner_code mtl_system_items_vl.planner_code%type;
305:
306: v_problem_model varchar2(1000) ;
307: v_problem_config varchar2(1000) ;
308: v_error_org varchar2(1000) ;

Line 1676: FROM mtl_system_items_vl item

1672: -- get the corresponding application user.
1673:
1674: SELECT u.user_name
1675: INTO lplanner_code
1676: FROM mtl_system_items_vl item
1677: ,mtl_planners p
1678: ,fnd_user u
1679: WHERE item.inventory_item_id = pModelId
1680: and item.organization_id = pOrgId

Line 1817: FROM mtl_system_items_vl item

1813: -- get the corresponding application user.
1814:
1815: SELECT u.user_name
1816: INTO lplanner_code
1817: FROM mtl_system_items_vl item
1818: ,mtl_planners p
1819: ,fnd_user u
1820: WHERE item.inventory_item_id = pModelId
1821: and item.organization_id = pOrgId

Line 5217: lplanner_code mtl_system_items_vl.planner_code%type;

5213: l_anumvalue wf_engine.numtabtyp;
5214: l_atxtvalue wf_engine.texttabtyp;
5215: luser_key varchar2(100);
5216: litem_key varchar2(100);
5217: lplanner_code mtl_system_items_vl.planner_code%type;
5218:
5219: porder_no number := 2222 ;
5220: pline_no number := 1111 ;
5221: