APPS.OE_BULK_PROCESS_LINE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 908: --hr_all_organization_units

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
912: FROM mtl_system_items msi,

Line 925: hr_all_organization_units org

921:
922: SELECT null
923: INTO l_dummy
924: FROM mtl_system_items msi,
925: hr_all_organization_units org
926: WHERE msi.inventory_item_id = p_inventory_item_id
927: AND org.organization_id= msi.organization_id
928: AND msi.internal_order_enabled_flag = 'Y'
929: AND sysdate <= nvl( org.date_to, sysdate)

Line 942: --hr_all_organization_units

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
946: FROM mtl_system_items msi,

Line 958: hr_all_organization_units org

954:
955: SELECT null
956: INTO l_dummy
957: FROM mtl_system_items msi,
958: hr_all_organization_units org
959: WHERE msi.inventory_item_id = p_inventory_item_id
960: AND org.organization_id= msi.organization_id
961: AND sysdate <= nvl( org.date_to, sysdate)
962: AND org.organization_id= p_ship_from_org_id

Line 967: --hr_all_organization_units

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
971: FROM mtl_system_items msi,

Line 984: hr_all_organization_units org

980:
981: SELECT null
982: INTO l_dummy
983: FROM mtl_system_items msi,
984: hr_all_organization_units org
985: WHERE msi.inventory_item_id = p_inventory_item_id
986: AND org.organization_id= msi.organization_id
987: AND msi.customer_order_enabled_flag = 'Y'
988: AND sysdate <= nvl( org.date_to, sysdate)