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 1702: FROM mtl_system_items_vl item

1698: -- get the corresponding application user.
1699:
1700: SELECT u.user_name
1701: INTO lplanner_code
1702: FROM mtl_system_items_vl item
1703: ,mtl_planners p
1704: ,fnd_user u
1705: WHERE item.inventory_item_id = pModelId
1706: and item.organization_id = pOrgId

Line 1843: FROM mtl_system_items_vl item

1839: -- get the corresponding application user.
1840:
1841: SELECT u.user_name
1842: INTO lplanner_code
1843: FROM mtl_system_items_vl item
1844: ,mtl_planners p
1845: ,fnd_user u
1846: WHERE item.inventory_item_id = pModelId
1847: and item.organization_id = pOrgId

Line 5529: lplanner_code mtl_system_items_vl.planner_code%type;

5525: l_anumvalue wf_engine.numtabtyp;
5526: l_atxtvalue wf_engine.texttabtyp;
5527: luser_key varchar2(100);
5528: litem_key varchar2(100);
5529: lplanner_code mtl_system_items_vl.planner_code%type;
5530:
5531: porder_no number := 2222 ;
5532: pline_no number := 1111 ;
5533: