DBA Data[Home] [Help]

APPS.CTO_CHANGE_ORDER_PK dependencies on MRP_SR_SOURCE_ORG

Line 738: mrp_sr_source_org src

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