DBA Data[Home] [Help]

APPS.OE_ATP dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 136: org_organization_definitions org

132: BEGIN
133: SELECT 1
134: INTO l_validity_flag
135: FROM mtl_system_items_b msi,
136: org_organization_definitions org
137: WHERE msi.inventory_item_id= p_line_atp_rec.inventory_item_id
138: AND org.organization_id=msi.organization_id
139: AND sysdate<=nvl(org.disable_date,sysdate)
140: AND org.organization_id=p_line_atp_rec.ship_from_org_id