DBA Data[Home] [Help]

APPS.OE_VALIDATE_LINE dependencies on MTL_CROSS_REFERENCE_TYPES

Line 1638: FROM mtl_cross_reference_types types

1634: item_val_org NUMBER := to_number(OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'));
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

Line 1655: FROM mtl_cross_reference_types types

1651: --cursor added for bug 3844345
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