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 509: bom_exclusion_rule_def d

505: BEGIN
506: SELECT '%'||d.exclusion_path || '%'
507: BULK COLLECT INTO exclusion_t
508: FROM bom_rules_b r,
509: bom_exclusion_rule_def d
510: WHERE d.rule_id = r.rule_id
511: AND d.from_revision_id IS NULL
512: AND d.implementation_date IS NOT NULL
513: AND d.disable_date IS NULL

Line 552: bom_exclusion_rule_def d

548: BEGIN
549: SELECT '%'||d.exclusion_path || '%'
550: BULK COLLECT INTO exclusion_t
551: FROM bom_rules_b r,
552: bom_exclusion_rule_def d
553: WHERE d.rule_id = r.rule_id
554: AND d.from_revision_id IS NULL
555: AND d.implementation_date IS NOT NULL
556: AND d.disable_date IS NULL

Line 4084: bom_exclusion_rule_def excl

4080: SELECT exclusion_path
4081: BULK COLLECT INTO rev_specific_exclusions_array
4082: FROM bom_explosions_all be,
4083: bom_rules_b rule,
4084: bom_exclusion_rule_def excl
4085: WHERE be.group_id = grp_id
4086: AND be.comp_bill_seq_id IS NOT NULL --get only the bills not its components
4087: AND be.comp_bill_seq_id = rule.bill_sequence_id
4088: AND rule.rule_id = excl.rule_id