DBA Data[Home] [Help]

APPS.BOM_EXPLODER_PUB dependencies on BOM_RULES_B

Line 520: FROM bom_rules_b r,

516: exclusion_t dbms_sql.varchar2_table;
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

Line 563: FROM bom_rules_b r,

559: exclusion_t dbms_sql.varchar2_table;
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

Line 4223: bom_rules_b rule,

4219:
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