DBA Data[Home] [Help]

APPS.OE_VALIDATE_LINE dependencies on MTL_CROSS_REFERENCES

Line 1639: , mtl_cross_references items

1635: CURSOR xref IS
1636: SELECT DECODE(items.org_independent_flag, 'Y', 1,
1637: DECODE(items.organization_id, item_val_org, 1, 2))
1638: FROM mtl_cross_reference_types types
1639: , mtl_cross_references items
1640: , mtl_system_items_vl sitems
1641: WHERE types.cross_reference_type = items.cross_reference_type
1642: AND items.inventory_item_id = sitems.inventory_item_id
1643: AND sitems.organization_id = item_val_org

Line 1656: , mtl_cross_references items

1652: CURSOR xref_return IS
1653: SELECT DECODE(items.org_independent_flag, 'Y', 1,
1654: DECODE(items.organization_id, item_val_org, 1, 2))
1655: FROM mtl_cross_reference_types types
1656: , mtl_cross_references items
1657: , mtl_system_items_vl sitems
1658: WHERE types.cross_reference_type = items.cross_reference_type
1659: AND items.inventory_item_id = sitems.inventory_item_id
1660: AND sitems.organization_id = item_val_org