DBA Data[Home] [Help]

APPS.GMD_QM_CONC_REPLACE_PKG dependencies on MTL_SYSTEM_ITEMS

Line 438: FROM mtl_system_items msi, gmd_specifications_b s

434:
435: -- Bug# 5882074 cursor definition to check for organization
436: CURSOR cur_check_item_org(p_org_id IN NUMBER, p_spec_id IN NUMBER) IS
437: SELECT msi.organization_id, msi.inventory_item_id, msi.revision_qty_control_code, s.revision
438: FROM mtl_system_items msi, gmd_specifications_b s
439: WHERE msi.organization_id = p_org_id
440: AND msi.inventory_item_id = s.inventory_item_id
441: AND s.spec_id = p_spec_id
442: AND msi.process_quality_enabled_flag = 'Y';