DBA Data[Home] [Help]

APPS.OE_INVOICE_PUB dependencies on MTL_CROSS_REFERENCES

Line 1137: , mtl_cross_references items

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
1141: AND sitems.organization_id = l_organization_id

Line 1292: , mtl_cross_references items

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
1296: AND sitems.organization_id = l_organization_id