DBA Data[Home] [Help]

APPS.OE_VALIDATE_LINE dependencies on MTL_CROSS_REFERENCES

Line 1663: , mtl_cross_references items

1659: CURSOR xref IS
1660: SELECT DECODE(items.org_independent_flag, 'Y', 1,
1661: DECODE(items.organization_id, item_val_org, 1, 2))
1662: FROM mtl_cross_reference_types types
1663: , mtl_cross_references items
1664: , mtl_system_items_vl sitems
1665: WHERE types.cross_reference_type = items.cross_reference_type
1666: AND items.inventory_item_id = sitems.inventory_item_id
1667: AND sitems.organization_id = item_val_org

Line 1680: , mtl_cross_references items

1676: CURSOR xref_return IS
1677: SELECT DECODE(items.org_independent_flag, 'Y', 1,
1678: DECODE(items.organization_id, item_val_org, 1, 2))
1679: FROM mtl_cross_reference_types types
1680: , mtl_cross_references items
1681: , mtl_system_items_vl sitems
1682: WHERE types.cross_reference_type = items.cross_reference_type
1683: AND items.inventory_item_id = sitems.inventory_item_id
1684: AND sitems.organization_id = item_val_org