734: select 'Y'
735: into l_valid_ship_from_org
736: from mrp_sr_assignments assg,
737: mrp_sr_receipt_org rcv,
738: mrp_sr_source_org src
739: where assg.inventory_item_id = lconfig_id
740: and assg.sourcing_rule_id = rcv.sourcing_rule_id
741: and rcv.effective_date <= sysdate
742: and nvl(rcv.disable_date,sysdate+1)>sysdate