DBA Data[Home] [Help]

APPS.OE_INVOICE_PUB dependencies on MTL_CROSS_REFERENCE_TYPES

Line 1136: FROM mtl_cross_reference_types types

1132: x_item_description := l_item_description ;
1133: ELSE
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

Line 1291: FROM mtl_cross_reference_types types

1287: ELSE
1288: oe_debug_pub.add('In else part of item identifier type',1);
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