APPS.OE_INVOICE_PUB dependencies on MTL_SYSTEM_ITEMS_VL

Line 1322: FROM mtl_system_items_vl

1318: END IF;
1319: IF nvl(p_line_rec.item_identifier_type,'INT') = 'INT' THEN -- Bug #3684306
1320: SELECT description
1321: INTO x_item_description
1322: FROM mtl_system_items_vl
1323: WHERE inventory_item_id =p_line_rec.inventory_item_id
1324: AND organization_id = l_organization_id;
1325: ELSIF nvl(p_line_rec.item_identifier_type,'INT') = 'CUST' THEN -- Bug #3684306
1326: -- changes for bug 4237123

Line 1331: ,mtl_system_items_vl sitems

1327: /*SELECT nvl(citems.customer_item_desc, sitems.description)
1328: INTO x_item_description
1329: FROM mtl_customer_items citems
1330: ,mtl_customer_item_xrefs cxref
1331: ,mtl_system_items_vl sitems
1332: WHERE citems.customer_item_id = cxref.customer_item_id
1333: AND cxref.inventory_item_id = sitems.inventory_item_id
1334: AND sitems.inventory_item_id = p_line_rec.inventory_item_id
1335: AND sitems.organization_id = l_organization_id

Line 1345: FROM mtl_system_items_vl sitems

1341: WHERE citems.customer_item_id = p_line_rec.ordered_item_id
1342: AND citems.customer_id = p_line_rec.sold_to_org_id;
1343: if l_item_description is null then
1344: SELECT sitems.description INTO l_item_description
1345: FROM mtl_system_items_vl sitems
1346: WHERE sitems.inventory_item_id = p_line_rec.inventory_item_id
1347: and sitems.organization_id = l_organization_id ;
1348: end if ;
1349: x_item_description := l_item_description ;

Line 1355: , mtl_system_items_vl sitems

1351: SELECT nvl(items.description, sitems.description)
1352: INTO x_item_description
1353: FROM mtl_cross_reference_types types
1354: , mtl_cross_references items
1355: , mtl_system_items_vl sitems
1356: WHERE types.cross_reference_type = items.cross_reference_type
1357: AND items.inventory_item_id = sitems.inventory_item_id
1358: AND sitems.organization_id = l_organization_id
1359: AND sitems.inventory_item_id = p_line_rec.inventory_item_id

Line 1375: FROM mtl_system_items_vl sitems

1371: oe_debug_pub.add('When no data found then get desc from system items '||SQLERRM,1);
1372: END IF;
1373: SELECT sitems.description
1374: INTO x_item_description
1375: FROM mtl_system_items_vl sitems
1376: WHERE sitems.inventory_item_id = p_line_rec.inventory_item_id
1377: and sitems.organization_id = l_organization_id ;
1378: WHEN OTHERS THEN
1379: IF l_debug_level > 0 THEN

Line 1469: FROM mtl_system_items_vl

1465: oe_debug_pub.add('Item identifier type is INT',1);
1466: BEGIN
1467: SELECT description
1468: INTO l_item_serviced_desc
1469: FROM mtl_system_items_vl
1470: WHERE inventory_item_id =l_inventory_item_id
1471: AND organization_id = l_organization_id;
1472: EXCEPTION
1473: WHEN NO_DATA_FOUND THEN

Line 1486: ,mtl_system_items_vl sitems

1482: /*SELECT nvl(citems.customer_item_desc, sitems.description)
1483: INTO l_item_serviced_desc
1484: FROM mtl_customer_items citems
1485: ,mtl_customer_item_xrefs cxref
1486: ,mtl_system_items_vl sitems
1487: WHERE citems.customer_item_id = cxref.customer_item_id
1488: AND cxref.inventory_item_id = sitems.inventory_item_id
1489: AND sitems.inventory_item_id = l_inventory_item_id
1490: AND sitems.organization_id = l_organization_id

Line 1500: FROM mtl_system_items_vl sitems

1496: WHERE citems.customer_item_id = l_ordered_item_id
1497: AND citems.customer_id = l_sold_to_org_id;
1498: if l_item_serviced_desc is null then
1499: SELECT sitems.description INTO l_item_serviced_desc
1500: FROM mtl_system_items_vl sitems
1501: WHERE sitems.inventory_item_id = l_inventory_item_id
1502: and sitems.organization_id = l_organization_id ;
1503: end if ;
1504: ELSE

Line 1510: , mtl_system_items_vl sitems

1506: SELECT nvl(items.description, sitems.description)
1507: INTO l_item_serviced_desc
1508: FROM mtl_cross_reference_types types
1509: , mtl_cross_references items
1510: , mtl_system_items_vl sitems
1511: WHERE types.cross_reference_type = items.cross_reference_type
1512: AND items.inventory_item_id = sitems.inventory_item_id
1513: AND sitems.organization_id = l_organization_id
1514: AND sitems.inventory_item_id = l_inventory_item_id

Line 1527: FROM mtl_system_items_vl sitems

1523: oe_debug_pub.add('When no data found then get desc from system items '||SQLERRM,1);
1524: END IF;
1525: SELECT sitems.description
1526: INTO l_item_serviced_desc
1527: FROM mtl_system_items_vl sitems
1528: WHERE sitems.inventory_item_id = l_inventory_item_id
1529: and sitems.organization_id = l_organization_id ;
1530: END ;
1531: END IF;