APPS.OE_BULK_PROCESS_LINE dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 389: From ORG_ORGANIZATION_DEFINITIONS

385: FND_MESSAGE.SET_TOKEN('ITEM',p_line_rec.ordered_item(p_index));
386:
387: Select ORGANIZATION_CODE
388: Into l_org_code
389: From ORG_ORGANIZATION_DEFINITIONS
390: Where ORGANIZATION_ID = l_org_id;
391: IF l_debug_level > 0 THEN
392: oe_debug_pub.add( 'ORGANIZATION CODE:'||L_ORG_CODE , 2 ) ;
393: END IF;

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

903:
904: /* for Internal Orders */
905: /* Internal Orders only support standard item */
906: IF p_source_document_type_id = 10 THEN
907: --perf bug 5121218, replace org_organization_definitions with
908: --hr_all_organization_units
909:
910: /* SELECT null
911: INTO l_dummy

Line 913: org_organization_definitions org

909:
910: /* SELECT null
911: INTO l_dummy
912: FROM mtl_system_items msi,
913: org_organization_definitions org
914: WHERE msi.inventory_item_id = p_inventory_item_id
915: AND org.organization_id= msi.organization_id
916: AND msi.internal_order_enabled_flag = 'Y'
917: AND sysdate <= nvl( org.disable_date, sysdate)

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

937: p_item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
938: (p_item_type_code = OE_GLOBALS.G_ITEM_KIT AND
939: nvl(p_top_model_line_id, -1) <> p_line_id)
940: THEN
941: --perf bug 5121218, replace org_organization_definitions with
942: --hr_all_organization_units
943:
944: /* SELECT null
945: INTO l_dummy

Line 947: org_organization_definitions org

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

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

962: AND org.organization_id= p_ship_from_org_id
963: AND rownum=1;
964:
965: ELSE /* item type is MODEL,STANDARD,SERVICE,KIT in top most level*/
966: --perf bug 5121218, replace org_organization_definitions with
967: --hr_all_organization_units
968:
969: /* SELECT null
970: INTO l_dummy

Line 972: org_organization_definitions org

968:
969: /* SELECT null
970: INTO l_dummy
971: FROM mtl_system_items msi,
972: org_organization_definitions org
973: WHERE msi.inventory_item_id = p_inventory_item_id
974: AND org.organization_id= msi.organization_id
975: AND msi.customer_order_enabled_flag = 'Y'
976: AND sysdate <= nvl( org.disable_date, sysdate)