APPS.OE_INVOICE_PUB dependencies on MTL_CUSTOMER_ITEMS

Line 1329: FROM mtl_customer_items citems

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

Line 1340: FROM mtl_customer_items citems

1336: AND citems.customer_item_id = p_line_rec.ordered_item_id
1337: AND citems.customer_id = p_line_rec.sold_to_org_id; */
1338:
1339: SELECT citems.customer_item_desc INTO l_item_description
1340: FROM mtl_customer_items citems
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

Line 1484: FROM mtl_customer_items citems

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

Line 1495: FROM mtl_customer_items citems

1491: AND citems.customer_item_id = l_ordered_item_id
1492: AND citems.customer_id = l_sold_to_org_id; */
1493:
1494: SELECT citems.customer_item_desc INTO l_item_serviced_desc
1495: FROM mtl_customer_items citems
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

Line 6383: FROM mtl_customer_items citems

6379: IF NVL(p_line_rec.item_identifier_type, 'INT') = 'CUST' THEN
6380: BEGIN
6381: SELECT customer_item_number
6382: INTO p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE9
6383: FROM mtl_customer_items citems
6384: WHERE customer_item_id = p_line_rec.ordered_item_id;
6385: EXCEPTION
6386: WHEN OTHERS THEN
6387: IF l_debug_level > 0 THEN