1817: AND bom_eamutil.serial_effective_item (item_id => p_from_item_id,
1818: org_id => p_reference_org_id
1819: ) = 'Y'
1820: )
1821: OR (pjm_unit_eff.enabled = 'Y'
1822: AND pjm_unit_eff.unit_effective_item
1823: (x_item_id => p_from_item_id,
1824: x_organization_id => p_reference_org_id
1825: ) = 'Y'
1818: org_id => p_reference_org_id
1819: ) = 'Y'
1820: )
1821: OR (pjm_unit_eff.enabled = 'Y'
1822: AND pjm_unit_eff.unit_effective_item
1823: (x_item_id => p_from_item_id,
1824: x_organization_id => p_reference_org_id
1825: ) = 'Y'
1826: )