DBA Data[Home] [Help]

APPS.OE_INVOICE_PUB dependencies on MTL_SYSTEM_ITEMS

Line 458: FROM mtl_system_items

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

Line 511: FROM oe_order_lines_all ol, mtl_system_items msi

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

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;

Line 2906: ,MTL_SYSTEM_ITEMS_SEG1

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

Line 2907: ,MTL_SYSTEM_ITEMS_SEG2

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

Line 2908: ,MTL_SYSTEM_ITEMS_SEG3

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

Line 2909: ,MTL_SYSTEM_ITEMS_SEG4

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

Line 2910: ,MTL_SYSTEM_ITEMS_SEG5

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

Line 2911: ,MTL_SYSTEM_ITEMS_SEG6

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

Line 2912: ,MTL_SYSTEM_ITEMS_SEG7

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

Line 2913: ,MTL_SYSTEM_ITEMS_SEG8

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

Line 2914: ,MTL_SYSTEM_ITEMS_SEG9

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

Line 2915: ,MTL_SYSTEM_ITEMS_SEG10

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

Line 2916: ,MTL_SYSTEM_ITEMS_SEG11

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

Line 2917: ,MTL_SYSTEM_ITEMS_SEG12

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

Line 2918: ,MTL_SYSTEM_ITEMS_SEG13

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

Line 2919: ,MTL_SYSTEM_ITEMS_SEG14

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

Line 2920: ,MTL_SYSTEM_ITEMS_SEG15

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

Line 2921: ,MTL_SYSTEM_ITEMS_SEG16

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

Line 2922: ,MTL_SYSTEM_ITEMS_SEG17

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

Line 2923: ,MTL_SYSTEM_ITEMS_SEG18

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

Line 2924: ,MTL_SYSTEM_ITEMS_SEG19

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

Line 2925: ,MTL_SYSTEM_ITEMS_SEG20

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

Line 3188: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG1

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

Line 3189: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG2

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

Line 3190: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG3

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

Line 3191: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG4

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

Line 3192: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG5

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

Line 3193: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG6

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

Line 3194: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG7

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

Line 3195: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG8

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

Line 3196: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG9

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

Line 3197: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG10

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

Line 3198: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG11

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

Line 3199: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG12

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

Line 3200: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG13

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

Line 3201: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG14

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

Line 3202: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG15

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

Line 3203: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG16

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

Line 3204: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG17

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

Line 3205: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG18

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

Line 3206: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG19

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

Line 3207: ,p_interface_line_rec.MTL_SYSTEM_ITEMS_SEG20

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

Line 4939: get description from mtl_system_items

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.

Line 4951: FROM mtl_system_items

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