454:
455: BEGIN
456: SELECT INVOICEABLE_ITEM_FLAG, INVOICE_ENABLED_FLAG
457: INTO l_invoiceable_item_flag, l_invoice_enabled_flag
458: FROM mtl_system_items
459: WHERE inventory_item_id = p_line_rec.inventory_item_id
460: AND organization_id = nvl(p_line_rec.ship_from_org_id,l_master_organization_id); --bug5336639
461:
462: EXCEPTION
507: BEGIN
508: /*Bug3261460*/
509: SELECT msi.SERVICEABLE_PRODUCT_FLAG
510: INTO l_serviceable_product_flag
511: FROM oe_order_lines_all ol, mtl_system_items msi
512: WHERE ol.line_id = l_service_reference_line_id
513: AND ol.inventory_item_id = msi.inventory_item_id
514: AND msi.organization_id = nvl(ol.ship_from_org_id, oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ol.org_id));
515: EXCEPTION
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
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
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 ;
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
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
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
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
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
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
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;
2902: ,AGREEMENT_ID
2903: ,MEMO_LINE_NAME
2904: ,MEMO_LINE_ID
2905: ,INVENTORY_ITEM_ID
2906: ,MTL_SYSTEM_ITEMS_SEG1
2907: ,MTL_SYSTEM_ITEMS_SEG2
2908: ,MTL_SYSTEM_ITEMS_SEG3
2909: ,MTL_SYSTEM_ITEMS_SEG4
2910: ,MTL_SYSTEM_ITEMS_SEG5
2903: ,MEMO_LINE_NAME
2904: ,MEMO_LINE_ID
2905: ,INVENTORY_ITEM_ID
2906: ,MTL_SYSTEM_ITEMS_SEG1
2907: ,MTL_SYSTEM_ITEMS_SEG2
2908: ,MTL_SYSTEM_ITEMS_SEG3
2909: ,MTL_SYSTEM_ITEMS_SEG4
2910: ,MTL_SYSTEM_ITEMS_SEG5
2911: ,MTL_SYSTEM_ITEMS_SEG6
2904: ,MEMO_LINE_ID
2905: ,INVENTORY_ITEM_ID
2906: ,MTL_SYSTEM_ITEMS_SEG1
2907: ,MTL_SYSTEM_ITEMS_SEG2
2908: ,MTL_SYSTEM_ITEMS_SEG3
2909: ,MTL_SYSTEM_ITEMS_SEG4
2910: ,MTL_SYSTEM_ITEMS_SEG5
2911: ,MTL_SYSTEM_ITEMS_SEG6
2912: ,MTL_SYSTEM_ITEMS_SEG7
2905: ,INVENTORY_ITEM_ID
2906: ,MTL_SYSTEM_ITEMS_SEG1
2907: ,MTL_SYSTEM_ITEMS_SEG2
2908: ,MTL_SYSTEM_ITEMS_SEG3
2909: ,MTL_SYSTEM_ITEMS_SEG4
2910: ,MTL_SYSTEM_ITEMS_SEG5
2911: ,MTL_SYSTEM_ITEMS_SEG6
2912: ,MTL_SYSTEM_ITEMS_SEG7
2913: ,MTL_SYSTEM_ITEMS_SEG8
2906: ,MTL_SYSTEM_ITEMS_SEG1
2907: ,MTL_SYSTEM_ITEMS_SEG2
2908: ,MTL_SYSTEM_ITEMS_SEG3
2909: ,MTL_SYSTEM_ITEMS_SEG4
2910: ,MTL_SYSTEM_ITEMS_SEG5
2911: ,MTL_SYSTEM_ITEMS_SEG6
2912: ,MTL_SYSTEM_ITEMS_SEG7
2913: ,MTL_SYSTEM_ITEMS_SEG8
2914: ,MTL_SYSTEM_ITEMS_SEG9
2907: ,MTL_SYSTEM_ITEMS_SEG2
2908: ,MTL_SYSTEM_ITEMS_SEG3
2909: ,MTL_SYSTEM_ITEMS_SEG4
2910: ,MTL_SYSTEM_ITEMS_SEG5
2911: ,MTL_SYSTEM_ITEMS_SEG6
2912: ,MTL_SYSTEM_ITEMS_SEG7
2913: ,MTL_SYSTEM_ITEMS_SEG8
2914: ,MTL_SYSTEM_ITEMS_SEG9
2915: ,MTL_SYSTEM_ITEMS_SEG10
2908: ,MTL_SYSTEM_ITEMS_SEG3
2909: ,MTL_SYSTEM_ITEMS_SEG4
2910: ,MTL_SYSTEM_ITEMS_SEG5
2911: ,MTL_SYSTEM_ITEMS_SEG6
2912: ,MTL_SYSTEM_ITEMS_SEG7
2913: ,MTL_SYSTEM_ITEMS_SEG8
2914: ,MTL_SYSTEM_ITEMS_SEG9
2915: ,MTL_SYSTEM_ITEMS_SEG10
2916: ,MTL_SYSTEM_ITEMS_SEG11
2909: ,MTL_SYSTEM_ITEMS_SEG4
2910: ,MTL_SYSTEM_ITEMS_SEG5
2911: ,MTL_SYSTEM_ITEMS_SEG6
2912: ,MTL_SYSTEM_ITEMS_SEG7
2913: ,MTL_SYSTEM_ITEMS_SEG8
2914: ,MTL_SYSTEM_ITEMS_SEG9
2915: ,MTL_SYSTEM_ITEMS_SEG10
2916: ,MTL_SYSTEM_ITEMS_SEG11
2917: ,MTL_SYSTEM_ITEMS_SEG12
2910: ,MTL_SYSTEM_ITEMS_SEG5
2911: ,MTL_SYSTEM_ITEMS_SEG6
2912: ,MTL_SYSTEM_ITEMS_SEG7
2913: ,MTL_SYSTEM_ITEMS_SEG8
2914: ,MTL_SYSTEM_ITEMS_SEG9
2915: ,MTL_SYSTEM_ITEMS_SEG10
2916: ,MTL_SYSTEM_ITEMS_SEG11
2917: ,MTL_SYSTEM_ITEMS_SEG12
2918: ,MTL_SYSTEM_ITEMS_SEG13
2911: ,MTL_SYSTEM_ITEMS_SEG6
2912: ,MTL_SYSTEM_ITEMS_SEG7
2913: ,MTL_SYSTEM_ITEMS_SEG8
2914: ,MTL_SYSTEM_ITEMS_SEG9
2915: ,MTL_SYSTEM_ITEMS_SEG10
2916: ,MTL_SYSTEM_ITEMS_SEG11
2917: ,MTL_SYSTEM_ITEMS_SEG12
2918: ,MTL_SYSTEM_ITEMS_SEG13
2919: ,MTL_SYSTEM_ITEMS_SEG14
2912: ,MTL_SYSTEM_ITEMS_SEG7
2913: ,MTL_SYSTEM_ITEMS_SEG8
2914: ,MTL_SYSTEM_ITEMS_SEG9
2915: ,MTL_SYSTEM_ITEMS_SEG10
2916: ,MTL_SYSTEM_ITEMS_SEG11
2917: ,MTL_SYSTEM_ITEMS_SEG12
2918: ,MTL_SYSTEM_ITEMS_SEG13
2919: ,MTL_SYSTEM_ITEMS_SEG14
2920: ,MTL_SYSTEM_ITEMS_SEG15
2913: ,MTL_SYSTEM_ITEMS_SEG8
2914: ,MTL_SYSTEM_ITEMS_SEG9
2915: ,MTL_SYSTEM_ITEMS_SEG10
2916: ,MTL_SYSTEM_ITEMS_SEG11
2917: ,MTL_SYSTEM_ITEMS_SEG12
2918: ,MTL_SYSTEM_ITEMS_SEG13
2919: ,MTL_SYSTEM_ITEMS_SEG14
2920: ,MTL_SYSTEM_ITEMS_SEG15
2921: ,MTL_SYSTEM_ITEMS_SEG16
2914: ,MTL_SYSTEM_ITEMS_SEG9
2915: ,MTL_SYSTEM_ITEMS_SEG10
2916: ,MTL_SYSTEM_ITEMS_SEG11
2917: ,MTL_SYSTEM_ITEMS_SEG12
2918: ,MTL_SYSTEM_ITEMS_SEG13
2919: ,MTL_SYSTEM_ITEMS_SEG14
2920: ,MTL_SYSTEM_ITEMS_SEG15
2921: ,MTL_SYSTEM_ITEMS_SEG16
2922: ,MTL_SYSTEM_ITEMS_SEG17
2915: ,MTL_SYSTEM_ITEMS_SEG10
2916: ,MTL_SYSTEM_ITEMS_SEG11
2917: ,MTL_SYSTEM_ITEMS_SEG12
2918: ,MTL_SYSTEM_ITEMS_SEG13
2919: ,MTL_SYSTEM_ITEMS_SEG14
2920: ,MTL_SYSTEM_ITEMS_SEG15
2921: ,MTL_SYSTEM_ITEMS_SEG16
2922: ,MTL_SYSTEM_ITEMS_SEG17
2923: ,MTL_SYSTEM_ITEMS_SEG18
2916: ,MTL_SYSTEM_ITEMS_SEG11
2917: ,MTL_SYSTEM_ITEMS_SEG12
2918: ,MTL_SYSTEM_ITEMS_SEG13
2919: ,MTL_SYSTEM_ITEMS_SEG14
2920: ,MTL_SYSTEM_ITEMS_SEG15
2921: ,MTL_SYSTEM_ITEMS_SEG16
2922: ,MTL_SYSTEM_ITEMS_SEG17
2923: ,MTL_SYSTEM_ITEMS_SEG18
2924: ,MTL_SYSTEM_ITEMS_SEG19
2917: ,MTL_SYSTEM_ITEMS_SEG12
2918: ,MTL_SYSTEM_ITEMS_SEG13
2919: ,MTL_SYSTEM_ITEMS_SEG14
2920: ,MTL_SYSTEM_ITEMS_SEG15
2921: ,MTL_SYSTEM_ITEMS_SEG16
2922: ,MTL_SYSTEM_ITEMS_SEG17
2923: ,MTL_SYSTEM_ITEMS_SEG18
2924: ,MTL_SYSTEM_ITEMS_SEG19
2925: ,MTL_SYSTEM_ITEMS_SEG20
2918: ,MTL_SYSTEM_ITEMS_SEG13
2919: ,MTL_SYSTEM_ITEMS_SEG14
2920: ,MTL_SYSTEM_ITEMS_SEG15
2921: ,MTL_SYSTEM_ITEMS_SEG16
2922: ,MTL_SYSTEM_ITEMS_SEG17
2923: ,MTL_SYSTEM_ITEMS_SEG18
2924: ,MTL_SYSTEM_ITEMS_SEG19
2925: ,MTL_SYSTEM_ITEMS_SEG20
2926: ,REFERENCE_LINE_ID
2919: ,MTL_SYSTEM_ITEMS_SEG14
2920: ,MTL_SYSTEM_ITEMS_SEG15
2921: ,MTL_SYSTEM_ITEMS_SEG16
2922: ,MTL_SYSTEM_ITEMS_SEG17
2923: ,MTL_SYSTEM_ITEMS_SEG18
2924: ,MTL_SYSTEM_ITEMS_SEG19
2925: ,MTL_SYSTEM_ITEMS_SEG20
2926: ,REFERENCE_LINE_ID
2927: ,REFERENCE_LINE_CONTEXT
2920: ,MTL_SYSTEM_ITEMS_SEG15
2921: ,MTL_SYSTEM_ITEMS_SEG16
2922: ,MTL_SYSTEM_ITEMS_SEG17
2923: ,MTL_SYSTEM_ITEMS_SEG18
2924: ,MTL_SYSTEM_ITEMS_SEG19
2925: ,MTL_SYSTEM_ITEMS_SEG20
2926: ,REFERENCE_LINE_ID
2927: ,REFERENCE_LINE_CONTEXT
2928: ,REFERENCE_LINE_ATTRIBUTE1
2921: ,MTL_SYSTEM_ITEMS_SEG16
2922: ,MTL_SYSTEM_ITEMS_SEG17
2923: ,MTL_SYSTEM_ITEMS_SEG18
2924: ,MTL_SYSTEM_ITEMS_SEG19
2925: ,MTL_SYSTEM_ITEMS_SEG20
2926: ,REFERENCE_LINE_ID
2927: ,REFERENCE_LINE_CONTEXT
2928: ,REFERENCE_LINE_ATTRIBUTE1
2929: ,REFERENCE_LINE_ATTRIBUTE2
3184: ,p_interface_line_rec.AGREEMENT_ID
3185: ,p_interface_line_rec.MEMO_LINE_NAME
3186: ,p_interface_line_rec.MEMO_LINE_ID
3187: ,p_interface_line_rec.INVENTORY_ITEM_ID
3188: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG1
3189: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG2
3190: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG3
3191: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG4
3192: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG5
3185: ,p_interface_line_rec.MEMO_LINE_NAME
3186: ,p_interface_line_rec.MEMO_LINE_ID
3187: ,p_interface_line_rec.INVENTORY_ITEM_ID
3188: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG1
3189: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG2
3190: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG3
3191: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG4
3192: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG5
3193: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG6
3186: ,p_interface_line_rec.MEMO_LINE_ID
3187: ,p_interface_line_rec.INVENTORY_ITEM_ID
3188: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG1
3189: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG2
3190: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG3
3191: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG4
3192: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG5
3193: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG6
3194: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG7
3187: ,p_interface_line_rec.INVENTORY_ITEM_ID
3188: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG1
3189: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG2
3190: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG3
3191: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG4
3192: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG5
3193: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG6
3194: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG7
3195: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG8
3188: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG1
3189: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG2
3190: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG3
3191: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG4
3192: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG5
3193: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG6
3194: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG7
3195: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG8
3196: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG9
3189: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG2
3190: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG3
3191: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG4
3192: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG5
3193: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG6
3194: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG7
3195: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG8
3196: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG9
3197: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG10
3190: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG3
3191: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG4
3192: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG5
3193: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG6
3194: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG7
3195: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG8
3196: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG9
3197: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG10
3198: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG11
3191: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG4
3192: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG5
3193: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG6
3194: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG7
3195: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG8
3196: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG9
3197: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG10
3198: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG11
3199: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG12
3192: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG5
3193: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG6
3194: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG7
3195: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG8
3196: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG9
3197: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG10
3198: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG11
3199: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG12
3200: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG13
3193: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG6
3194: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG7
3195: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG8
3196: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG9
3197: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG10
3198: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG11
3199: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG12
3200: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG13
3201: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG14
3194: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG7
3195: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG8
3196: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG9
3197: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG10
3198: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG11
3199: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG12
3200: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG13
3201: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG14
3202: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG15
3195: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG8
3196: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG9
3197: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG10
3198: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG11
3199: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG12
3200: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG13
3201: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG14
3202: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG15
3203: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG16
3196: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG9
3197: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG10
3198: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG11
3199: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG12
3200: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG13
3201: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG14
3202: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG15
3203: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG16
3204: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG17
3197: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG10
3198: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG11
3199: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG12
3200: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG13
3201: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG14
3202: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG15
3203: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG16
3204: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG17
3205: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG18
3198: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG11
3199: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG12
3200: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG13
3201: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG14
3202: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG15
3203: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG16
3204: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG17
3205: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG18
3206: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG19
3199: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG12
3200: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG13
3201: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG14
3202: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG15
3203: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG16
3204: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG17
3205: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG18
3206: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG19
3207: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG20
3200: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG13
3201: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG14
3202: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG15
3203: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG16
3204: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG17
3205: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG18
3206: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG19
3207: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG20
3208: ,p_interface_line_rec.REFERENCE_LINE_ID
3201: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG14
3202: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG15
3203: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG16
3204: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG17
3205: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG18
3206: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG19
3207: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG20
3208: ,p_interface_line_rec.REFERENCE_LINE_ID
3209: ,p_interface_line_rec.REFERENCE_LINE_CONTEXT
3202: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG15
3203: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG16
3204: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG17
3205: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG18
3206: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG19
3207: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG20
3208: ,p_interface_line_rec.REFERENCE_LINE_ID
3209: ,p_interface_line_rec.REFERENCE_LINE_CONTEXT
3210: ,p_interface_line_rec.REFERENCE_LINE_ATTRIBUTE1
3203: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG16
3204: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG17
3205: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG18
3206: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG19
3207: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG20
3208: ,p_interface_line_rec.REFERENCE_LINE_ID
3209: ,p_interface_line_rec.REFERENCE_LINE_CONTEXT
3210: ,p_interface_line_rec.REFERENCE_LINE_ATTRIBUTE1
3211: ,p_interface_line_rec.REFERENCE_LINE_ATTRIBUTE2
4935: o inventory_item_id = NULL
4936: o description = lookup meaning for FREIGHT
4937: o line_type = 'FREIGHT'
4938: if vat = 'Y' and freight_as_line = 'Y' and freight_item not null
4939: get description from mtl_system_items
4940: else
4941: get description from ar_lookups */
4942:
4943: -- per bug 2382340, take out the dependency on AR_ALLOW_TAX_CODE_OVERRIDE.
4947: SELECT description
4948: ,primary_uom_code
4949: INTO p_x_charges_rec.Description
4950: ,p_x_charges_rec.Uom_Code
4951: FROM mtl_system_items
4952: WHERE inventory_item_id = l_freight_item
4953: AND organization_id = oe_sys_parameters.value('MASTER_ORGANIZATION_ID', p_line_rec.org_id);
4954: ELSE
4955: SELECT meaning