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