DBA Data[Home] [Help]

APPS.GMD_QM_CONC_REPLACE_PKG dependencies on MTL_SYSTEM_ITEMS

Line 447: FROM mtl_system_items msi, gmd_specifications_b s

443:
444: -- Bug# 5882074 cursor definition to check for organization
445: CURSOR cur_check_item_org(p_org_id IN NUMBER, p_spec_id IN NUMBER) IS
446: SELECT msi.organization_id, msi.inventory_item_id, msi.revision_qty_control_code, s.revision
447: FROM mtl_system_items msi, gmd_specifications_b s
448: WHERE msi.organization_id = p_org_id
449: AND msi.inventory_item_id = s.inventory_item_id
450: AND s.spec_id = p_spec_id
451: AND msi.process_quality_enabled_flag = 'Y';