DBA Data[Home] [Help]

APPS.OE_INVOICE_PUB dependencies on MTL_CROSS_REFERENCES

Line 1354: , mtl_cross_references items

1350: ELSE
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

Line 1509: , mtl_cross_references items

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