APPS.IMC_REPORTS_SUMMARY_PKG dependencies on IMC_DUPL_RANGE_V

Line 723: imc_dupl_range_v rng

719: AND hp.status = 'A'
720: AND hs.identifying_address_flag (+) = 'Y'
721: AND hs.location_id = hl.location_id (+)
722: GROUP BY hp.customer_key || hl.address_key, hp.party_type) x,
723: imc_dupl_range_v rng
724: WHERE ((x.org_count between rng.min and rng.max)
725: OR (x.per_count between rng.min and rng.max))
726: GROUP BY rng.dupl_rng, rng.rng_no, ptype
727: ) allcount

Line 795: FROM imc_dupl_range_v rng

791: decode(rng.rng_no, 0, rp_msg_no_dupl,
792: 1, rng.dupl_rng || ' ' || rp_msg_dupl,
793: rng.dupl_rng || ' ' || rp_msg_dupls),
794: rng.rng_no, 0, 0, sysdate
795: FROM imc_dupl_range_v rng
796: WHERE NOT EXISTS (SELECT '1' FROM imc_reports_tempinfo tmp
797: WHERE tmp.report_name = 'DUPLICATE'
798: AND tmp.report_type = 'R'
799: AND tmp.parent_category = rng.rng_no);