APPS.OE_INVOICE_PUB dependencies on MTL_SYSTEM_ITEMS

Line 664: FROM mtl_system_items

660:
661: BEGIN
662: SELECT INVOICEABLE_ITEM_FLAG, INVOICE_ENABLED_FLAG
663: INTO l_invoiceable_item_flag, l_invoice_enabled_flag
664: FROM mtl_system_items
665: WHERE inventory_item_id = p_line_rec.inventory_item_id
666: AND organization_id = nvl(p_line_rec.ship_from_org_id,l_master_organization_id); --bug5336639
667:
668: EXCEPTION

Line 717: FROM oe_order_lines_all ol, mtl_system_items msi

713: BEGIN
714: /*Bug3261460*/
715: SELECT msi.SERVICEABLE_PRODUCT_FLAG
716: INTO l_serviceable_product_flag
717: FROM oe_order_lines_all ol, mtl_system_items msi
718: WHERE ol.line_id = l_service_reference_line_id
719: AND ol.inventory_item_id = msi.inventory_item_id
720: AND msi.organization_id = nvl(ol.ship_from_org_id, oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ol.org_id));
721: EXCEPTION

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;

Line 3134: ,MTL_SYSTEM_ITEMS_SEG1

3130: ,AGREEMENT_ID
3131: ,MEMO_LINE_NAME
3132: ,MEMO_LINE_ID
3133: ,INVENTORY_ITEM_ID
3134: ,MTL_SYSTEM_ITEMS_SEG1
3135: ,MTL_SYSTEM_ITEMS_SEG2
3136: ,MTL_SYSTEM_ITEMS_SEG3
3137: ,MTL_SYSTEM_ITEMS_SEG4
3138: ,MTL_SYSTEM_ITEMS_SEG5

Line 3135: ,MTL_SYSTEM_ITEMS_SEG2

3131: ,MEMO_LINE_NAME
3132: ,MEMO_LINE_ID
3133: ,INVENTORY_ITEM_ID
3134: ,MTL_SYSTEM_ITEMS_SEG1
3135: ,MTL_SYSTEM_ITEMS_SEG2
3136: ,MTL_SYSTEM_ITEMS_SEG3
3137: ,MTL_SYSTEM_ITEMS_SEG4
3138: ,MTL_SYSTEM_ITEMS_SEG5
3139: ,MTL_SYSTEM_ITEMS_SEG6

Line 3136: ,MTL_SYSTEM_ITEMS_SEG3

3132: ,MEMO_LINE_ID
3133: ,INVENTORY_ITEM_ID
3134: ,MTL_SYSTEM_ITEMS_SEG1
3135: ,MTL_SYSTEM_ITEMS_SEG2
3136: ,MTL_SYSTEM_ITEMS_SEG3
3137: ,MTL_SYSTEM_ITEMS_SEG4
3138: ,MTL_SYSTEM_ITEMS_SEG5
3139: ,MTL_SYSTEM_ITEMS_SEG6
3140: ,MTL_SYSTEM_ITEMS_SEG7

Line 3137: ,MTL_SYSTEM_ITEMS_SEG4

3133: ,INVENTORY_ITEM_ID
3134: ,MTL_SYSTEM_ITEMS_SEG1
3135: ,MTL_SYSTEM_ITEMS_SEG2
3136: ,MTL_SYSTEM_ITEMS_SEG3
3137: ,MTL_SYSTEM_ITEMS_SEG4
3138: ,MTL_SYSTEM_ITEMS_SEG5
3139: ,MTL_SYSTEM_ITEMS_SEG6
3140: ,MTL_SYSTEM_ITEMS_SEG7
3141: ,MTL_SYSTEM_ITEMS_SEG8

Line 3138: ,MTL_SYSTEM_ITEMS_SEG5

3134: ,MTL_SYSTEM_ITEMS_SEG1
3135: ,MTL_SYSTEM_ITEMS_SEG2
3136: ,MTL_SYSTEM_ITEMS_SEG3
3137: ,MTL_SYSTEM_ITEMS_SEG4
3138: ,MTL_SYSTEM_ITEMS_SEG5
3139: ,MTL_SYSTEM_ITEMS_SEG6
3140: ,MTL_SYSTEM_ITEMS_SEG7
3141: ,MTL_SYSTEM_ITEMS_SEG8
3142: ,MTL_SYSTEM_ITEMS_SEG9

Line 3139: ,MTL_SYSTEM_ITEMS_SEG6

3135: ,MTL_SYSTEM_ITEMS_SEG2
3136: ,MTL_SYSTEM_ITEMS_SEG3
3137: ,MTL_SYSTEM_ITEMS_SEG4
3138: ,MTL_SYSTEM_ITEMS_SEG5
3139: ,MTL_SYSTEM_ITEMS_SEG6
3140: ,MTL_SYSTEM_ITEMS_SEG7
3141: ,MTL_SYSTEM_ITEMS_SEG8
3142: ,MTL_SYSTEM_ITEMS_SEG9
3143: ,MTL_SYSTEM_ITEMS_SEG10

Line 3140: ,MTL_SYSTEM_ITEMS_SEG7

3136: ,MTL_SYSTEM_ITEMS_SEG3
3137: ,MTL_SYSTEM_ITEMS_SEG4
3138: ,MTL_SYSTEM_ITEMS_SEG5
3139: ,MTL_SYSTEM_ITEMS_SEG6
3140: ,MTL_SYSTEM_ITEMS_SEG7
3141: ,MTL_SYSTEM_ITEMS_SEG8
3142: ,MTL_SYSTEM_ITEMS_SEG9
3143: ,MTL_SYSTEM_ITEMS_SEG10
3144: ,MTL_SYSTEM_ITEMS_SEG11

Line 3141: ,MTL_SYSTEM_ITEMS_SEG8

3137: ,MTL_SYSTEM_ITEMS_SEG4
3138: ,MTL_SYSTEM_ITEMS_SEG5
3139: ,MTL_SYSTEM_ITEMS_SEG6
3140: ,MTL_SYSTEM_ITEMS_SEG7
3141: ,MTL_SYSTEM_ITEMS_SEG8
3142: ,MTL_SYSTEM_ITEMS_SEG9
3143: ,MTL_SYSTEM_ITEMS_SEG10
3144: ,MTL_SYSTEM_ITEMS_SEG11
3145: ,MTL_SYSTEM_ITEMS_SEG12

Line 3142: ,MTL_SYSTEM_ITEMS_SEG9

3138: ,MTL_SYSTEM_ITEMS_SEG5
3139: ,MTL_SYSTEM_ITEMS_SEG6
3140: ,MTL_SYSTEM_ITEMS_SEG7
3141: ,MTL_SYSTEM_ITEMS_SEG8
3142: ,MTL_SYSTEM_ITEMS_SEG9
3143: ,MTL_SYSTEM_ITEMS_SEG10
3144: ,MTL_SYSTEM_ITEMS_SEG11
3145: ,MTL_SYSTEM_ITEMS_SEG12
3146: ,MTL_SYSTEM_ITEMS_SEG13

Line 3143: ,MTL_SYSTEM_ITEMS_SEG10

3139: ,MTL_SYSTEM_ITEMS_SEG6
3140: ,MTL_SYSTEM_ITEMS_SEG7
3141: ,MTL_SYSTEM_ITEMS_SEG8
3142: ,MTL_SYSTEM_ITEMS_SEG9
3143: ,MTL_SYSTEM_ITEMS_SEG10
3144: ,MTL_SYSTEM_ITEMS_SEG11
3145: ,MTL_SYSTEM_ITEMS_SEG12
3146: ,MTL_SYSTEM_ITEMS_SEG13
3147: ,MTL_SYSTEM_ITEMS_SEG14

Line 3144: ,MTL_SYSTEM_ITEMS_SEG11

3140: ,MTL_SYSTEM_ITEMS_SEG7
3141: ,MTL_SYSTEM_ITEMS_SEG8
3142: ,MTL_SYSTEM_ITEMS_SEG9
3143: ,MTL_SYSTEM_ITEMS_SEG10
3144: ,MTL_SYSTEM_ITEMS_SEG11
3145: ,MTL_SYSTEM_ITEMS_SEG12
3146: ,MTL_SYSTEM_ITEMS_SEG13
3147: ,MTL_SYSTEM_ITEMS_SEG14
3148: ,MTL_SYSTEM_ITEMS_SEG15

Line 3145: ,MTL_SYSTEM_ITEMS_SEG12

3141: ,MTL_SYSTEM_ITEMS_SEG8
3142: ,MTL_SYSTEM_ITEMS_SEG9
3143: ,MTL_SYSTEM_ITEMS_SEG10
3144: ,MTL_SYSTEM_ITEMS_SEG11
3145: ,MTL_SYSTEM_ITEMS_SEG12
3146: ,MTL_SYSTEM_ITEMS_SEG13
3147: ,MTL_SYSTEM_ITEMS_SEG14
3148: ,MTL_SYSTEM_ITEMS_SEG15
3149: ,MTL_SYSTEM_ITEMS_SEG16

Line 3146: ,MTL_SYSTEM_ITEMS_SEG13

3142: ,MTL_SYSTEM_ITEMS_SEG9
3143: ,MTL_SYSTEM_ITEMS_SEG10
3144: ,MTL_SYSTEM_ITEMS_SEG11
3145: ,MTL_SYSTEM_ITEMS_SEG12
3146: ,MTL_SYSTEM_ITEMS_SEG13
3147: ,MTL_SYSTEM_ITEMS_SEG14
3148: ,MTL_SYSTEM_ITEMS_SEG15
3149: ,MTL_SYSTEM_ITEMS_SEG16
3150: ,MTL_SYSTEM_ITEMS_SEG17

Line 3147: ,MTL_SYSTEM_ITEMS_SEG14

3143: ,MTL_SYSTEM_ITEMS_SEG10
3144: ,MTL_SYSTEM_ITEMS_SEG11
3145: ,MTL_SYSTEM_ITEMS_SEG12
3146: ,MTL_SYSTEM_ITEMS_SEG13
3147: ,MTL_SYSTEM_ITEMS_SEG14
3148: ,MTL_SYSTEM_ITEMS_SEG15
3149: ,MTL_SYSTEM_ITEMS_SEG16
3150: ,MTL_SYSTEM_ITEMS_SEG17
3151: ,MTL_SYSTEM_ITEMS_SEG18

Line 3148: ,MTL_SYSTEM_ITEMS_SEG15

3144: ,MTL_SYSTEM_ITEMS_SEG11
3145: ,MTL_SYSTEM_ITEMS_SEG12
3146: ,MTL_SYSTEM_ITEMS_SEG13
3147: ,MTL_SYSTEM_ITEMS_SEG14
3148: ,MTL_SYSTEM_ITEMS_SEG15
3149: ,MTL_SYSTEM_ITEMS_SEG16
3150: ,MTL_SYSTEM_ITEMS_SEG17
3151: ,MTL_SYSTEM_ITEMS_SEG18
3152: ,MTL_SYSTEM_ITEMS_SEG19

Line 3149: ,MTL_SYSTEM_ITEMS_SEG16

3145: ,MTL_SYSTEM_ITEMS_SEG12
3146: ,MTL_SYSTEM_ITEMS_SEG13
3147: ,MTL_SYSTEM_ITEMS_SEG14
3148: ,MTL_SYSTEM_ITEMS_SEG15
3149: ,MTL_SYSTEM_ITEMS_SEG16
3150: ,MTL_SYSTEM_ITEMS_SEG17
3151: ,MTL_SYSTEM_ITEMS_SEG18
3152: ,MTL_SYSTEM_ITEMS_SEG19
3153: ,MTL_SYSTEM_ITEMS_SEG20

Line 3150: ,MTL_SYSTEM_ITEMS_SEG17

3146: ,MTL_SYSTEM_ITEMS_SEG13
3147: ,MTL_SYSTEM_ITEMS_SEG14
3148: ,MTL_SYSTEM_ITEMS_SEG15
3149: ,MTL_SYSTEM_ITEMS_SEG16
3150: ,MTL_SYSTEM_ITEMS_SEG17
3151: ,MTL_SYSTEM_ITEMS_SEG18
3152: ,MTL_SYSTEM_ITEMS_SEG19
3153: ,MTL_SYSTEM_ITEMS_SEG20
3154: ,REFERENCE_LINE_ID

Line 3151: ,MTL_SYSTEM_ITEMS_SEG18

3147: ,MTL_SYSTEM_ITEMS_SEG14
3148: ,MTL_SYSTEM_ITEMS_SEG15
3149: ,MTL_SYSTEM_ITEMS_SEG16
3150: ,MTL_SYSTEM_ITEMS_SEG17
3151: ,MTL_SYSTEM_ITEMS_SEG18
3152: ,MTL_SYSTEM_ITEMS_SEG19
3153: ,MTL_SYSTEM_ITEMS_SEG20
3154: ,REFERENCE_LINE_ID
3155: ,REFERENCE_LINE_CONTEXT

Line 3152: ,MTL_SYSTEM_ITEMS_SEG19

3148: ,MTL_SYSTEM_ITEMS_SEG15
3149: ,MTL_SYSTEM_ITEMS_SEG16
3150: ,MTL_SYSTEM_ITEMS_SEG17
3151: ,MTL_SYSTEM_ITEMS_SEG18
3152: ,MTL_SYSTEM_ITEMS_SEG19
3153: ,MTL_SYSTEM_ITEMS_SEG20
3154: ,REFERENCE_LINE_ID
3155: ,REFERENCE_LINE_CONTEXT
3156: ,REFERENCE_LINE_ATTRIBUTE1

Line 3153: ,MTL_SYSTEM_ITEMS_SEG20

3149: ,MTL_SYSTEM_ITEMS_SEG16
3150: ,MTL_SYSTEM_ITEMS_SEG17
3151: ,MTL_SYSTEM_ITEMS_SEG18
3152: ,MTL_SYSTEM_ITEMS_SEG19
3153: ,MTL_SYSTEM_ITEMS_SEG20
3154: ,REFERENCE_LINE_ID
3155: ,REFERENCE_LINE_CONTEXT
3156: ,REFERENCE_LINE_ATTRIBUTE1
3157: ,REFERENCE_LINE_ATTRIBUTE2

Line 3417: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG1

3413: ,p_interface_line_rec.AGREEMENT_ID
3414: ,p_interface_line_rec.MEMO_LINE_NAME
3415: ,p_interface_line_rec.MEMO_LINE_ID
3416: ,p_interface_line_rec.INVENTORY_ITEM_ID
3417: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG1
3418: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG2
3419: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG3
3420: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG4
3421: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG5

Line 3418: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG2

3414: ,p_interface_line_rec.MEMO_LINE_NAME
3415: ,p_interface_line_rec.MEMO_LINE_ID
3416: ,p_interface_line_rec.INVENTORY_ITEM_ID
3417: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG1
3418: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG2
3419: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG3
3420: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG4
3421: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG5
3422: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG6

Line 3419: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG3

3415: ,p_interface_line_rec.MEMO_LINE_ID
3416: ,p_interface_line_rec.INVENTORY_ITEM_ID
3417: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG1
3418: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG2
3419: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG3
3420: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG4
3421: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG5
3422: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG6
3423: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG7

Line 3420: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG4

3416: ,p_interface_line_rec.INVENTORY_ITEM_ID
3417: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG1
3418: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG2
3419: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG3
3420: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG4
3421: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG5
3422: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG6
3423: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG7
3424: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG8

Line 3421: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG5

3417: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG1
3418: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG2
3419: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG3
3420: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG4
3421: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG5
3422: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG6
3423: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG7
3424: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG8
3425: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG9

Line 3422: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG6

3418: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG2
3419: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG3
3420: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG4
3421: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG5
3422: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG6
3423: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG7
3424: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG8
3425: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG9
3426: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG10

Line 3423: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG7

3419: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG3
3420: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG4
3421: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG5
3422: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG6
3423: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG7
3424: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG8
3425: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG9
3426: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG10
3427: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG11

Line 3424: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG8

3420: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG4
3421: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG5
3422: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG6
3423: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG7
3424: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG8
3425: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG9
3426: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG10
3427: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG11
3428: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG12

Line 3425: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG9

3421: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG5
3422: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG6
3423: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG7
3424: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG8
3425: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG9
3426: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG10
3427: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG11
3428: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG12
3429: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG13

Line 3426: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG10

3422: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG6
3423: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG7
3424: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG8
3425: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG9
3426: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG10
3427: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG11
3428: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG12
3429: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG13
3430: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG14

Line 3427: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG11

3423: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG7
3424: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG8
3425: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG9
3426: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG10
3427: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG11
3428: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG12
3429: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG13
3430: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG14
3431: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG15

Line 3428: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG12

3424: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG8
3425: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG9
3426: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG10
3427: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG11
3428: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG12
3429: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG13
3430: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG14
3431: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG15
3432: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG16

Line 3429: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG13

3425: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG9
3426: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG10
3427: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG11
3428: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG12
3429: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG13
3430: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG14
3431: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG15
3432: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG16
3433: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG17

Line 3430: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG14

3426: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG10
3427: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG11
3428: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG12
3429: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG13
3430: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG14
3431: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG15
3432: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG16
3433: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG17
3434: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG18

Line 3431: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG15

3427: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG11
3428: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG12
3429: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG13
3430: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG14
3431: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG15
3432: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG16
3433: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG17
3434: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG18
3435: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG19

Line 3432: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG16

3428: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG12
3429: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG13
3430: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG14
3431: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG15
3432: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG16
3433: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG17
3434: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG18
3435: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG19
3436: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG20

Line 3433: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG17

3429: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG13
3430: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG14
3431: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG15
3432: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG16
3433: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG17
3434: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG18
3435: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG19
3436: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG20
3437: ,p_interface_line_rec.REFERENCE_LINE_ID

Line 3434: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG18

3430: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG14
3431: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG15
3432: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG16
3433: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG17
3434: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG18
3435: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG19
3436: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG20
3437: ,p_interface_line_rec.REFERENCE_LINE_ID
3438: ,p_interface_line_rec.REFERENCE_LINE_CONTEXT

Line 3435: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG19

3431: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG15
3432: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG16
3433: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG17
3434: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG18
3435: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG19
3436: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG20
3437: ,p_interface_line_rec.REFERENCE_LINE_ID
3438: ,p_interface_line_rec.REFERENCE_LINE_CONTEXT
3439: ,p_interface_line_rec.REFERENCE_LINE_ATTRIBUTE1

Line 3436: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG20

3432: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG16
3433: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG17
3434: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG18
3435: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG19
3436: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG20
3437: ,p_interface_line_rec.REFERENCE_LINE_ID
3438: ,p_interface_line_rec.REFERENCE_LINE_CONTEXT
3439: ,p_interface_line_rec.REFERENCE_LINE_ATTRIBUTE1
3440: ,p_interface_line_rec.REFERENCE_LINE_ATTRIBUTE2

Line 5170: get description from mtl_system_items

5166: o inventory_item_id = NULL
5167: o description = lookup meaning for FREIGHT
5168: o line_type = 'FREIGHT'
5169: if vat = 'Y' and freight_as_line = 'Y' and freight_item not null
5170: get description from mtl_system_items
5171: else
5172: get description from ar_lookups */
5173:
5174: -- per bug 2382340, take out the dependency on AR_ALLOW_TAX_CODE_OVERRIDE.

Line 5182: FROM mtl_system_items

5178: SELECT description
5179: ,primary_uom_code
5180: INTO p_x_charges_rec.Description
5181: ,p_x_charges_rec.Uom_Code
5182: FROM mtl_system_items
5183: WHERE inventory_item_id = l_freight_item
5184: AND organization_id = oe_sys_parameters.value('MASTER_ORGANIZATION_ID', p_line_rec.org_id);
5185: ELSE
5186: SELECT meaning