APPS.OE_CNCL_VALIDATE_LINE dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 445: org_organization_definitions org

441: OE_DEBUG_PUB.Add('Entering OE_CNCL_VALIDATE_LINE.Validate_Receiving_Org',1);
442: SELECT null
443: INTO l_dummy
444: FROM mtl_system_items msi,
445: org_organization_definitions org
446: WHERE msi.inventory_item_id = p_inventory_item_id
447: AND org.organization_id= msi.organization_id
448: AND org.organization_id= p_ship_from_org_id
449: AND org.set_of_books_id= ( SELECT fsp.set_of_books_id

Line 491: org_organization_definitions org

487: THEN
488: SELECT null
489: INTO l_dummy
490: FROM mtl_system_items msi,
491: org_organization_definitions org
492: WHERE msi.inventory_item_id = p_inventory_item_id
493: AND org.organization_id= msi.organization_id
494: AND org.organization_id= p_ship_from_org_id
495: AND rownum=1;

Line 500: org_organization_definitions org

496: ELSE
497: SELECT null
498: INTO l_dummy
499: FROM mtl_system_items msi,
500: org_organization_definitions org
501: WHERE msi.inventory_item_id = p_inventory_item_id
502: AND org.organization_id= msi.organization_id
503: AND org.organization_id= p_ship_from_org_id
504: AND rownum=1;

Line 1081: org_organization_definitions org

1077:
1078: SELECT purchasing_enabled_flag
1079: INTO l_purchasing_enabled_flag
1080: FROM mtl_system_items msi,
1081: org_organization_definitions org
1082: WHERE msi.inventory_item_id = p_line_rec.inventory_item_id
1083: AND org.organization_id= msi.organization_id
1084: AND sysdate <= nvl( org.disable_date, sysdate)
1085: AND org.organization_id = nvl(p_line_rec.ship_from_org_id,