eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_EXPLODER_PUB dependencies on BOM_EXCLUSION_RULE_DEF

Line 521: bom_exclusion_rule_def d

517: BEGIN
518: SELECT '%'||d.exclusion_path || '%'
519: BULK COLLECT INTO exclusion_t
520: FROM bom_rules_b r,
521: bom_exclusion_rule_def d
522: WHERE d.rule_id = r.rule_id
523: AND d.from_revision_id IS NULL
524: AND d.implementation_date IS NOT NULL
525: AND d.disable_date IS NULL

Line 564: bom_exclusion_rule_def d

560: BEGIN
561: SELECT '%'||d.exclusion_path || '%'
562: BULK COLLECT INTO exclusion_t
563: FROM bom_rules_b r,
564: bom_exclusion_rule_def d
565: WHERE d.rule_id = r.rule_id
566: AND d.from_revision_id IS NULL
567: AND d.implementation_date IS NOT NULL
568: AND d.disable_date IS NULL

Line 4224: bom_exclusion_rule_def excl

4220: SELECT exclusion_path
4221: BULK COLLECT INTO rev_specific_exclusions_array
4222: FROM bom_explosions_all be,
4223: bom_rules_b rule,
4224: bom_exclusion_rule_def excl
4225: WHERE be.group_id = grp_id
4226: AND be.comp_bill_seq_id IS NOT NULL --get only the bills not its components
4227: AND be.comp_bill_seq_id = rule.bill_sequence_id
4228: AND rule.rule_id = excl.rule_id