APPS.OE_INVOICE_PUB dependencies on MTL_CUSTOMER_ITEMS

Line 1112: FROM mtl_customer_items citems

1108: ELSIF nvl(p_line_rec.item_identifier_type,'INT') = 'CUST' THEN -- Bug #3684306
1109: -- changes for bug 4237123
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

Line 1123: FROM mtl_customer_items citems

1119: AND citems.customer_item_id = p_line_rec.ordered_item_id
1120: AND citems.customer_id = p_line_rec.sold_to_org_id; */
1121:
1122: SELECT citems.customer_item_desc INTO l_item_description
1123: FROM mtl_customer_items citems
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

Line 1267: FROM mtl_customer_items citems

1263: oe_debug_pub.add('Item Identifier typs is CUST',1);
1264: -- changes for bug 4237123
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

Line 1278: FROM mtl_customer_items citems

1274: AND citems.customer_item_id = l_ordered_item_id
1275: AND citems.customer_id = l_sold_to_org_id; */
1276:
1277: SELECT citems.customer_item_desc INTO l_item_serviced_desc
1278: FROM mtl_customer_items citems
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

Line 6125: FROM mtl_customer_items citems

6121: IF NVL(p_line_rec.item_identifier_type, 'INT') = 'CUST' THEN
6122: BEGIN
6123: SELECT customer_item_number
6124: INTO p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE9
6125: FROM mtl_customer_items citems
6126: WHERE customer_item_id = p_line_rec.ordered_item_id;
6127: EXCEPTION
6128: WHEN OTHERS THEN
6129: IF l_debug_level > 0 THEN