APPS.ECEPOI dependencies on MTL_SYSTEM_ITEMS_VL

Line 498: FROM mtl_system_items_vl

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

Line 515: FROM mtl_system_items_vl sitems

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

Line 526: FROM mtl_system_items_vl sitems

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

Line 534: , mtl_system_items_vl sitems

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

Line 550: FROM mtl_system_items_vl sitems

546: WHEN NO_DATA_FOUND THEN
547: ec_debug.pl(3,'When no data found then get desc from system items ',SQLERRM);
548: SELECT sitems.description
549: INTO x_item_description
550: FROM mtl_system_items_vl sitems
551: WHERE sitems.inventory_item_id = p_inventory_item_id
552: AND sitems.organization_id = l_organization_id ;
553: WHEN OTHERS THEN
554: oe_debug_pub.add('Unable to get Item Description '||SQLERRM,1);