APPS.ECEPOI dependencies on MTL_SYSTEM_ITEMS_VL

Line 500: FROM mtl_system_items_vl

496:
497: IF (p_item_identifier_type) = 'INT' THEN
498: SELECT description
499: INTO x_item_description
500: FROM mtl_system_items_vl
501: WHERE inventory_item_id = p_inventory_item_id
502: AND organization_id = l_organization_id;
503:
504: ELSIF NVL(p_item_identifier_type,'INT') = 'CUST' THEN

Line 517: FROM mtl_system_items_vl sitems

513:
514: IF l_item_description IS NULL THEN
515: SELECT sitems.description
516: INTO l_item_description
517: FROM mtl_system_items_vl sitems
518: WHERE sitems.inventory_item_id = p_inventory_item_id
519: AND sitems.organization_id = l_organization_id ;
520: END IF ;
521:

Line 528: FROM mtl_system_items_vl sitems

524: ELSE
525: /*
526: SELECT sitems.description
527: INTO x_item_description
528: FROM mtl_system_items_vl sitems
529: WHERE sitems.inventory_item_id = p_inventory_item_id
530: AND sitems.organization_id = l_organization_id ;
531: */
532: SELECT NVL(items.description, sitems.description)

Line 536: , mtl_system_items_vl sitems

532: SELECT NVL(items.description, sitems.description)
533: INTO x_item_description
534: FROM mtl_cross_reference_types types
535: , mtl_cross_references items
536: , mtl_system_items_vl sitems
537: WHERE types.cross_reference_type = items.cross_reference_type
538: AND items.inventory_item_id = sitems.inventory_item_id
539: AND sitems.organization_id = l_organization_id
540: AND sitems.inventory_item_id = p_inventory_item_id

Line 553: FROM mtl_system_items_vl sitems

549: ec_debug.pl(3,'When no data found then get desc from system items ',SQLERRM);
550: begin --bug7554911
551: SELECT sitems.description
552: INTO x_item_description
553: FROM mtl_system_items_vl sitems
554: WHERE sitems.inventory_item_id = p_inventory_item_id
555: AND sitems.organization_id = l_organization_id ;
556: EXCEPTION
557: WHEN OTHERS THEN