DBA Data[Home] [Help]

APPS.OE_INVOICE_PUB dependencies on MTL_SYSTEM_ITEMS_VL

Line 1105: FROM mtl_system_items_vl

1101: END IF;
1102: IF nvl(p_line_rec.item_identifier_type,'INT') = 'INT' THEN -- Bug #3684306
1103: SELECT description
1104: INTO x_item_description
1105: FROM mtl_system_items_vl
1106: WHERE inventory_item_id =p_line_rec.inventory_item_id
1107: AND organization_id = l_organization_id;
1108: ELSIF nvl(p_line_rec.item_identifier_type,'INT') = 'CUST' THEN -- Bug #3684306
1109: -- changes for bug 4237123

Line 1114: ,mtl_system_items_vl sitems

1110: /*SELECT nvl(citems.customer_item_desc, sitems.description)
1111: INTO x_item_description
1112: FROM mtl_customer_items citems
1113: ,mtl_customer_item_xrefs cxref
1114: ,mtl_system_items_vl sitems
1115: WHERE citems.customer_item_id = cxref.customer_item_id
1116: AND cxref.inventory_item_id = sitems.inventory_item_id
1117: AND sitems.inventory_item_id = p_line_rec.inventory_item_id
1118: AND sitems.organization_id = l_organization_id

Line 1128: FROM mtl_system_items_vl sitems

1124: WHERE citems.customer_item_id = p_line_rec.ordered_item_id
1125: AND citems.customer_id = p_line_rec.sold_to_org_id;
1126: if l_item_description is null then
1127: SELECT sitems.description INTO l_item_description
1128: FROM mtl_system_items_vl sitems
1129: WHERE sitems.inventory_item_id = p_line_rec.inventory_item_id
1130: and sitems.organization_id = l_organization_id ;
1131: end if ;
1132: x_item_description := l_item_description ;

Line 1138: , mtl_system_items_vl sitems

1134: SELECT nvl(items.description, sitems.description)
1135: INTO x_item_description
1136: FROM mtl_cross_reference_types types
1137: , mtl_cross_references items
1138: , mtl_system_items_vl sitems
1139: WHERE types.cross_reference_type = items.cross_reference_type
1140: AND items.inventory_item_id = sitems.inventory_item_id
1141: AND sitems.organization_id = l_organization_id
1142: AND sitems.inventory_item_id = p_line_rec.inventory_item_id

Line 1158: FROM mtl_system_items_vl sitems

1154: oe_debug_pub.add('When no data found then get desc from system items '||SQLERRM,1);
1155: END IF;
1156: SELECT sitems.description
1157: INTO x_item_description
1158: FROM mtl_system_items_vl sitems
1159: WHERE sitems.inventory_item_id = p_line_rec.inventory_item_id
1160: and sitems.organization_id = l_organization_id ;
1161: WHEN OTHERS THEN
1162: IF l_debug_level > 0 THEN

Line 1252: FROM mtl_system_items_vl

1248: oe_debug_pub.add('Item identifier type is INT',1);
1249: BEGIN
1250: SELECT description
1251: INTO l_item_serviced_desc
1252: FROM mtl_system_items_vl
1253: WHERE inventory_item_id =l_inventory_item_id
1254: AND organization_id = l_organization_id;
1255: EXCEPTION
1256: WHEN NO_DATA_FOUND THEN

Line 1269: ,mtl_system_items_vl sitems

1265: /*SELECT nvl(citems.customer_item_desc, sitems.description)
1266: INTO l_item_serviced_desc
1267: FROM mtl_customer_items citems
1268: ,mtl_customer_item_xrefs cxref
1269: ,mtl_system_items_vl sitems
1270: WHERE citems.customer_item_id = cxref.customer_item_id
1271: AND cxref.inventory_item_id = sitems.inventory_item_id
1272: AND sitems.inventory_item_id = l_inventory_item_id
1273: AND sitems.organization_id = l_organization_id

Line 1283: FROM mtl_system_items_vl sitems

1279: WHERE citems.customer_item_id = l_ordered_item_id
1280: AND citems.customer_id = l_sold_to_org_id;
1281: if l_item_serviced_desc is null then
1282: SELECT sitems.description INTO l_item_serviced_desc
1283: FROM mtl_system_items_vl sitems
1284: WHERE sitems.inventory_item_id = l_inventory_item_id
1285: and sitems.organization_id = l_organization_id ;
1286: end if ;
1287: ELSE

Line 1293: , mtl_system_items_vl sitems

1289: SELECT nvl(items.description, sitems.description)
1290: INTO l_item_serviced_desc
1291: FROM mtl_cross_reference_types types
1292: , mtl_cross_references items
1293: , mtl_system_items_vl sitems
1294: WHERE types.cross_reference_type = items.cross_reference_type
1295: AND items.inventory_item_id = sitems.inventory_item_id
1296: AND sitems.organization_id = l_organization_id
1297: AND sitems.inventory_item_id = l_inventory_item_id

Line 1310: FROM mtl_system_items_vl sitems

1306: oe_debug_pub.add('When no data found then get desc from system items '||SQLERRM,1);
1307: END IF;
1308: SELECT sitems.description
1309: INTO l_item_serviced_desc
1310: FROM mtl_system_items_vl sitems
1311: WHERE sitems.inventory_item_id = l_inventory_item_id
1312: and sitems.organization_id = l_organization_id ;
1313: END ;
1314: END IF;