APPS.OE_BULK_PROCESS_LINE dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 363: From ORG_ORGANIZATION_DEFINITIONS

359: FND_MESSAGE.SET_TOKEN('ITEM',p_line_rec.ordered_item(p_index));
360:
361: Select ORGANIZATION_CODE
362: Into l_org_code
363: From ORG_ORGANIZATION_DEFINITIONS
364: Where ORGANIZATION_ID = l_org_id;
365: IF l_debug_level > 0 THEN
366: oe_debug_pub.add( 'ORGANIZATION CODE:'||L_ORG_CODE , 2 ) ;
367: END IF;

Line 881: --perf bug 5121218, replace org_organization_definitions with

877:
878: /* for Internal Orders */
879: /* Internal Orders only support standard item */
880: IF p_source_document_type_id = 10 THEN
881: --perf bug 5121218, replace org_organization_definitions with
882: --hr_all_organization_units
883:
884: /* SELECT null
885: INTO l_dummy

Line 887: org_organization_definitions org

883:
884: /* SELECT null
885: INTO l_dummy
886: FROM mtl_system_items msi,
887: org_organization_definitions org
888: WHERE msi.inventory_item_id = p_inventory_item_id
889: AND org.organization_id= msi.organization_id
890: AND msi.internal_order_enabled_flag = 'Y'
891: AND sysdate <= nvl( org.disable_date, sysdate)

Line 915: --perf bug 5121218, replace org_organization_definitions with

911: p_item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
912: (p_item_type_code = OE_GLOBALS.G_ITEM_KIT AND
913: nvl(p_top_model_line_id, -1) <> p_line_id)
914: THEN
915: --perf bug 5121218, replace org_organization_definitions with
916: --hr_all_organization_units
917:
918: /* SELECT null
919: INTO l_dummy

Line 921: org_organization_definitions org

917:
918: /* SELECT null
919: INTO l_dummy
920: FROM mtl_system_items msi,
921: org_organization_definitions org
922: WHERE msi.inventory_item_id = p_inventory_item_id
923: AND org.organization_id= msi.organization_id
924: AND sysdate <= nvl( org.disable_date, sysdate)
925: AND org.organization_id= p_ship_from_org_id

Line 940: --perf bug 5121218, replace org_organization_definitions with

936: AND org.organization_id= p_ship_from_org_id
937: AND rownum=1;
938:
939: ELSE /* item type is MODEL,STANDARD,SERVICE,KIT in top most level*/
940: --perf bug 5121218, replace org_organization_definitions with
941: --hr_all_organization_units
942:
943: /* SELECT null
944: INTO l_dummy

Line 946: org_organization_definitions org

942:
943: /* SELECT null
944: INTO l_dummy
945: FROM mtl_system_items msi,
946: org_organization_definitions org
947: WHERE msi.inventory_item_id = p_inventory_item_id
948: AND org.organization_id= msi.organization_id
949: AND msi.customer_order_enabled_flag = 'Y'
950: AND sysdate <= nvl( org.disable_date, sysdate)